Re: Table optimization ideas needed
| From: | Chris | Date: | Wed, 26 Mar 2008 02:20:12 +0000 |
| Subject: | Re: Table optimization ideas needed | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-44796@lists.php.net to get a copy of this message | ||
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/