zekova
-
Posts
4 -
Joined
-
Last visited
zekova's Achievements
Newbie (1/5)
0
Reputation
-
Execution Time: Finding a File vs. Finding a Row in MySQL
zekova replied to zekova's topic in PHP Coding Help
Right, but thousands of consecutive queries might take more mem and cpu power than calling up a specific filename, no? -
Execution Time: Finding a File vs. Finding a Row in MySQL
zekova replied to zekova's topic in PHP Coding Help
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!