M
Michael N
Guest
I have a MySQL database that stores data from an XML feed in the following way:
My application gets data from the XML feed, but it's likely that I will want to refer to the data again (over the period of the next few hours/minutes), so I throw it in the database to avoid having to go back to the slow XML feed more than necessary.
My question is, is there any sense in having a second cache in memory, for fast access?
What is the difference in lookup time between some array in my php program, and a MySQL database, assuming they hold the same type of data.
It's probably important to know that my database server is on the same machine that the application is running on.
My application gets data from the XML feed, but it's likely that I will want to refer to the data again (over the period of the next few hours/minutes), so I throw it in the database to avoid having to go back to the slow XML feed more than necessary.
My question is, is there any sense in having a second cache in memory, for fast access?
What is the difference in lookup time between some array in my php program, and a MySQL database, assuming they hold the same type of data.
It's probably important to know that my database server is on the same machine that the application is running on.