Should i convert the following script to php+mysql, will the performance increase (less cpu, faster script execution).
pseudo-code:
- get environment variables
- read a text file
- search for a spefic record
- add or update (when record exists) record
- close text file
The text file contains a maximum of 20 lines (each line is about 30 characters long).
The scripts can sometimes get 10/20 hits per second.
I'm particular worried about that mysql locks the whole table when i update/delete/add a record, should i be worried about this?, cause with every hit my script does a update/delete/add. I'm also worried that connecting to a database will be slower the opening a small file.
pseudo-code:
- get environment variables
- read a text file
- search for a spefic record
- add or update (when record exists) record
- close text file
The text file contains a maximum of 20 lines (each line is about 30 characters long).
The scripts can sometimes get 10/20 hits per second.
I'm particular worried about that mysql locks the whole table when i update/delete/add a record, should i be worried about this?, cause with every hit my script does a update/delete/add. I'm also worried that connecting to a database will be slower the opening a small file.