My data types are similar to those in your example. Using the
suggestions on your page, I was able to increase performance a fair
bit. I'm able to get near 240,000 inserts/second on my 3GHz Xeon Linux
system with your example program.
I did find a place for optimization in the btree code whi
--- Al Danial <[EMAIL PROTECTED]> wrote:
> On 7/21/05, Chuck Pahlmeyer - MTI <[EMAIL PROTECTED]>
> wrote:
> > I have an application in which I'd like to create a
> database as
> > quickly as possible. The application has a batch
> process at
> > startup which creates the data. I am using a singl
On 7/21/05, Chuck Pahlmeyer - MTI <[EMAIL PROTECTED]> wrote:
> I have an application in which I'd like to create a database as
> quickly as possible. The application has a batch process at
> startup which creates the data. I am using a single transaction
> for all of the INSERT statements. I'm also
Have you tried postgresql? I haven't run any time tests myself, yet.
http://www.postgresql.org
You might also want to look away from SQL databases entirely and use
an unstructured database such as BerkeleyDB. Sometimes you don't need
the overhead of structure.
http://www.sleepycat.com
Af
I have an application in which I'd like to create a database as
quickly as possible. The application has a batch process at
startup which creates the data. I am using a single transaction
for all of the INSERT statements. I'm also using prepared statements
to alleviate some of the overhead for pro
5 matches
Mail list logo
