Newsgroups: comp.databases.oracle.server
From: pobox...@bebub.com
Date: 2 Jun 2005 17:40:12 -0700
Local: Thurs, Jun 2 2005 8:40 pm
Subject: Re: Oracle and Dotnet
There is something else wrong here, it is not the database that is
limiting you to such a low insert rate. What happens if you connect using sqlplus and do this On a laptop I am getting about 15,000 inserts per second. I would look SQL> create table t (n number); Table created. Elapsed: 00:00:00.28 PL/SQL procedure successfully completed. Elapsed: 00:00:06.68 INSERTS_PER_SEC This is also using a loop construct which is about the slowest method SQL> insert into t 100000 rows created. Elapsed: 00:00:04.85 INSERTS_PER_SEC This is on a pretty low powered, 4 year old windows laptop with 512 MB -- You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| ||||||||||||||