Shelley wrote:
Yes, Index can help a lot.
But actually there has been five indices. The table takes 1.4G space while the indices take 2.3G.
The select sentence is still slow.  :(

Post your exact query, table definition(s), indexes and see if anyone has some suggestions.

If it's a mysql db, join one of the mysql lists and see if anyone has some suggestions (though they will ask for the same info). Same for any other db.

Postgresql & php tutorials

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to