MySQL Forums
Forum List  »  InnoDB

Re: partitioning of a table
Posted by: Harold Content
Date: June 02, 2014 02:09AM

The slowest of all is this one, where the actual insert happens

string_sql = "SELECT tbldebart.* FROM tbldebart;"
rstnw.Open string_sql, CNNAPP, adOpenDynamic, adLockOptimistic
rstnw.AddNew
rstnw!aid = KP_Artikel_ID
rstnw!deid = KP_DEB_ID
rstnw!debart_af = SourceLAW_AF
rstnw!debart_o0 = SourceLAW_OM0
rstnw!debart_of = SourceLAW_OMF
rstnw!debart_week = lbweeknummer.Caption
rstnw!debart_jaar = lbjaartal.Caption
rstnw.Update
rstnw.Close

Options: ReplyQuote


Subject
Views
Written By
Posted
1888
May 01, 2014 05:25AM
944
May 02, 2014 10:51AM
999
May 05, 2014 07:31AM
933
May 05, 2014 07:54AM
980
May 06, 2014 06:02PM
814
May 07, 2014 03:20AM
854
May 08, 2014 08:50AM
Re: partitioning of a table
972
June 02, 2014 02:09AM
917
June 02, 2014 09:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.