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/[EMAIL PROTECTED]
