On Mon, Aug 23, 2004 at 03:45:28PM -0500, Victor Pendleton wrote: > Why don't you disable the indexes before the load and enable the indexes > after the data load?
If I'm bulk-loading a fresh install of data, then I'll be using un-indexed tables and index them afterwards. Otherwise, I want to keep the indexes on the table, and index as I go along (so that when I'm done I don't have to re-index from scratch). In response to the other poster, who suggested opening the table up in some utility: it's not a problem for _me_ to determine if I'm bulk-loading a new batch, or adding to an existing database. I want my loading program to be able to determine this without any input from me. Thanks. Jesse Sheidlower -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
