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
Postgresql & php tutorials
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php