zekova
-
Posts
4 -
Joined
-
Last visited
Posts posted by zekova
-
-
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!
Execution Time: Finding a File vs. Finding a Row in MySQL
in PHP Coding Help
Posted
Right, but thousands of consecutive queries might take more mem and cpu power than calling up a specific filename, no?