Some database search tips

[dhimok]

Hello.

I have this database where I get like thousand of searches every day. But I think it is running a bit slow. Do you have any tips on how to improve it and keeping it flow. Thanks a lot

[infid3l]

If you only need to return X amount of results, always add this to the end of your SQL query:

 

LIMIT x

 

For example:

 

SELECT username FROM user_db WHERE name='Ted' LIMIT 5

[ryeman98]

If you only need to return X amount of results, always add this to the end of your SQL query:

 

LIMIT x

 

For example:

 

SELECT username FROM user_db WHERE name='Ted' LIMIT 5

 

That will work good too. You may also want to look up Pagination to limit the amount of results per page.

Good luck!