fast sqlquery

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
sebs
Forum Commoner
Posts: 97
Joined: Tue Sep 20, 2005 10:13 am

fast sqlquery

Post by sebs »

Do you know a way to make a fastest select statement from a db in mysql.I have to make a select from over 150000 elements in the database and it takes a long time to do it.Is the index useful only for using join?I am using PHP if it helps you with something.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Read the documentation for you DBMS, they will likely have stuff on how to optimize the speed of a query. EXPLAIN (an SQL keyword) may help you as well.

Moved to Databases.
Post Reply