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 : [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
