I guess it's a matter of how fast it goes. The script will run consecutively, so it'll be a lot of requests one after another.
So I assume it's best to search for filename instead, thanks jazzman!
What if I have 100,000 rows in a MySQL table, and a 100,000 files in a directory, each file representing a row in the MySQL table....
Which, in your experience, is faster to find? A file called 123456789.csv or a record where id='123456789'?
Any input is appreciated, thanks!
All you need to do is run your sendmail script after inserting the data into mysql if it's a new record.
For checking existing records, look into MySQL count. It will return a number of records. Use php if statement to decide if you should do something.
Good luck!
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.