Portal Home > Knowledgebase > Articles Database > How many sql's in a page
How many sql's in a page
Posted by hq12, 06-12-2007, 08:33 AM |
I am doind a php script, and i wonder What is a reasonable number of sqls searches in a database per page?
Some comments please! Thanks.
hq12
|
Posted by Ks Jeppe, 06-12-2007, 09:42 AM |
You can't really put a number on them... It all comes down to what you're doing, and how well your database is indexed... I've seen scripts with 20-30 queries per page which load in a matter of miliseconds, and other pages with only 3 queries which take 20 secs..
What type of queries are you doing, and are you doing them on a well optimized and indexed database?
|
Posted by hq12, 06-12-2007, 04:08 PM |
Thanks KsJeppe for the response, currently i am doing the queries just in the columns of the mysql database; I have used indexed database yet. Can you refer me to a link where i can learn how to use indexes? thanks again. HQ12
|
Add to Favourites Print this Article
Also Read