SQL performance
#6

When performing queries and your only returning a set amount of data/rows, use LIMIT, for example if your logging someone in SELECT * FROM table WHERE(username = username, password = password) LIMIT 1;
Reply


Messages In This Thread
SQL performance - by Dabombber - 24.09.2009, 10:07
Re: SQL performance - by V1ceC1ty - 24.09.2009, 10:36
Re: SQL performance - by Kyosaur - 24.09.2009, 10:39
Re: SQL performance - by Dabombber - 24.09.2009, 10:44
Re: SQL performance - by Misiek - 24.09.2009, 11:56
Re: SQL performance - by gotenks918 - 24.09.2009, 12:27
Re: SQL performance - by Dabombber - 24.09.2009, 15:31
Re: SQL performance - by RoBo - 24.09.2009, 15:49

Forum Jump:


Users browsing this thread: 1 Guest(s)