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
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to