× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



> From: Joe Pluta
> 
> I was not surprised to find that, as usual, WRITE is ten times faster
> than INSERT VALUES.  However, I WAS very interested to find that
INSERT
> VALUES was actually a tiny bit FASTER than INSERT data structure.  And
> while INSERT MODS of ten rows was a smidge faster than INSERT VALUES
> (less than 1% faster), INSERT MODS with 100 rows was actually SLOWER
> than INSERT MODS with ten rows.  And finally, all four techniques were
> within 1% of each other, and all were ten times as slow as native I/O.

I HATE when that happens...

I should have been suspicious of the results.  I knew it.  While the
numbers on the INSERT VALUES and INSERT DS are correct, the INSERT MODS
was bogus.  I was running the wrong program.

The test results are MUCH more realistic now:

1. INSERT 10 rows at a time is three times slower than WRITE
2. INSERT 100 rows at a time is 25% faster than WRITE

So it looks like the break-even point, at least for SQL INSERT vs.
blocked WRITE, is somewhere around 80 rows or so at a time.  But even at
more modest 10 rows at a time, it's not a horrible amount of overhead.

But record at a time INSERTs, no matter how you slice them, are awful.

Joe


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.