> Other ways means change your DB design or application.
> One tip: insert more records together without commit and perform only one
> commit at the end.

It might also be worthwhile to reconsider the indices and use an additional search mechanism (ie lucene or sphinx or another search tool).

Mark
--
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01