Re: VdB5.6 table to SQL server 6.5 table

Article View: borland.public.vdbase.data.sql

Article #883

Back to borland.public.vdbase.data.sql Previous Next

#883

From: Paul Franks
Date: Sun, 21 Jun 1998 00:00

13 lines
975 bytes

In article <358B11A6.7F28348@ibm.net>, gswass@ibm.net says...
> If you turn off
> AutoCommit and then in your program take responsibility for
> beginTrans/Commit/Rollback, then you can do things in batches and then
> commit. I am not sure if you can do all 50,000 rows, 
> 

Ouch!!! think of the size of the transaction log.  I suspect it would 
first hit some limit for the number of locks required, but I have no idea 
what numeric limit would apply or if it could be configured.
-- 
Paul Franks (TeamB)

Technical Details

Message-ID: <MPG.ff740914229eb4b98977d@forums.inprise.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <6me4at$c441@forums.borland.com> <358B11A6.7F28348@ibm.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,aab9967d5bc578d4
X-Google-Attributes: gidff5a1,public
From: supportinfo@borland.com (Paul Franks)
Subject: Re: VdB5.6 table to SQL server 6.5 table
Date: 1998/06/21
Message-ID: <MPG.ff740914229eb4b98977d@forums.inprise.com>
X-Deja-AN: 364750558
References: <6me4at$c441@forums.borland.com> <358B11A6.7F28348@ibm.net>
Organization: TeamB
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message