Re: [PHP-DB] Table optimization ideas needed

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/