Forum Moderators: open
$query="SELECT columnName From tableName WHERE id= 'this'";
etc...
would this slow down processing/loading time of a page?
The reason i ask this is because I have so many queries from my database on my php page from different tables in order to populate and create the page. Now at the moment on localhost it doesn't seem to take much time at all to load, but im not sure how fast the page will load once my site is live.
Does it tend to be the same?
Database round-trips are expensive, time wise. I would like into ways to combine your twenty queries (maybe joins or sub queries).
Of course, the fastest database access is *no* database access - caching the output of your database calls will keep things speedy.
[edited by: Dilly at 2:28 pm (utc) on Sep. 9, 2007]
I actually meant caching your HTML pages. Run your queries, build your page, write it out to a static file and then serve that until your data changes.
I would look at combining queries if at all possible.
Make sure you have the mysql query cache turned on.
Look at caching the HTML page, or parts of the page
Look into using memcached to cache all the data into one key, and invalidate it when the source changes.
Sean
Personally I combine it with PHP objects (OOP5) which get stored in memcached to enable very fast state, query result and session storage and reconsitution.
