Re: your mail (fwd)

Posted in 1992

Naomi Walker — Wed, 25 Nov 92 16:40:35 MST — source: Informix-list mailing list archive (1991-1998)

(resend, because I sent the message out before it was done) Paul, First off, when I have to load a bunch of rows into a table, I prefer to use dbload, because you can let it count transactions. I believe the default is 200 between commits. The number of locks not only has to do with the number of rows, but the number of indicies. There will be one lock created for each for each row for each index (ie. 10k rows, 2 indicies, 20k locks). Also, if you lock the table in exclusive mode, and do everything in one transaction, you may overflow your logs, so be aware. Thats another reason I love dbload. Naomi -- Naomi Walker (aka N7FSA) naomi%anasaz.UUCP@asuvax.eas.asu.edu Enthusiasm is caught, In tennis, not taught. love means nothing.