Forum Moderators: coopster

Message Too Old, No Replies

Multi SQL Queries?

         

Sarah Atkinson

2:26 am on May 17, 2006 (gmt 0)

10+ Year Member



I know we should try and use as few quarries as possible right to help with server efficiency. But just how critical is this?

eelixduppy

2:45 am on May 17, 2006 (gmt 0)



It depends on the situation. Sometimes multiple queries are better than just one.

Sarah Atkinson

3:21 am on May 17, 2006 (gmt 0)

10+ Year Member



but how will they effect server performance? Will they bog it down?

siMKin

9:48 am on May 17, 2006 (gmt 0)

10+ Year Member



It really depends on the situation.
If you're worried about perfomance you should just test the speed of your queries (either on the command prompt or with a little script that you insert in the complete code).
Everyone does this, even the most experienced users. Why? Because every sitation is different.

henry0

11:13 am on May 17, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Review: Here [webmasterworld.com]