Am 21.09.2004 13:27 schrieb Alain Reymond:
>
> Do you have any idea how I can improve speed - apart from splitting
> the table every 2 or 3 years which is the the aim of a database!
>
Drop the index before you insert the data and recreate it afterwards.
Use the "copy from ..." command instead of "insert into".
Greetings,
Martin
--
Martin Knipper
www : http://www.mk-os.de
Mail : knipper@mk-os.de