Big databases

[phpmotion]

How do you get scripts to search huge DBs in fewer seconds?

[geek]

Optimize the scripts and make sure your mySQL (if that is what you use) is optimized.

[wilber]

Indexes are very important especially on parts of the script where there are joins.

[clipshare]

Indexing your database is good but what really is good is optimizing your queries.

[wilber]

Well of course, most times the slowdown comes because of joins in the query that really slows it.

[geek]

Joins are very complex when it comes to coding you always need to have that as optimized as possible.

[wilber]

What is a good way to make an optimal query using a join and limit in the statement?