[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    looking for some base line stats
From:       "MaxDB - Mailing List" <maxdb () altavistasolutions ! com>
Date:       2004-03-25 19:01:10
Message-ID: FFEJIFDFDIGGOJMMPHDJGEBCCIAA.maxdb () altavistasolutions ! com
[Download RAW message or body]

Hello and thank you all for your great help.  I am almost rolling on MaxDB
and it is due to your help.

That being said, I have another question for you.  I have looked through the
list for ways to speed up inserts.  I have turned AUTOCOMMIT off and am
using transactions in the connection. I have watched the log and it never
gets above 17% full so I don't think that is the issue.  I am inserting
about 400000 rows using a stored procedure.  I am reading from and access DB
and then inserting to the MaxDB.  I take the values from the AccessDB. Then
with MaxDB, I do a lookup for an indexed column (X) from table A and use VB
with stored procedure to pass the value of X, along with the values from the
Access DB, as a parameters for a stored procedure to insert into table B.
Using this method I can get about 80 rows every 30 seconds.  This is to slow
as it will take 41 hours to process the 400,000 rows.  Is there anything I
can do to speed this up or is the as fast as MaxDB gets?

Thanks for your help in advance again!


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=sapdb-general@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]