Subject | Re: [ib-support] Cached Updates |
---|---|
Author | hans@hoogstraat.ca |
Post date | 2001-08-19T02:38:13Z |
That is the drawback of Netscape 3. Can be set very safe to avoid
virrii, but all message in one pool
Thank U:
=====================================================
Helen Borrie wrote:
virrii, but all message in one pool
Thank U:
=====================================================
Helen Borrie wrote:
>
> Hans,
> You seem to have posted this to the ib-support list by mistake...
>
> Regards,
> Helen
> (Mod)
>
> At 07:49 PM 18-08-01 -0600, you wrote:
> >Importing data and blobs via TIB_Query
> >
> >while ...
> >begin
> >TIB_Query.Append;
> >TIB_Query['Field'].As.... := Info ;
> >TIB_Query.Post;
> >end;
> >
> >works fine. Blobs import great.
> >
> >Now to speed things up, I use CachedUpdates := True
> >with ApplyUpdates and Commit every 1000 records.
> >
> >count := 0;
> >
> >while ...
> >begin
> >TIB_Query.Append;
> >TIB_Query['Field'].As.... := Info ;
> >TIB_Query.Post;
> >
> >inc(count);
> >if mod(count,1000) = 0 then
> > ApplyUpdates and Commit
> >end;
> >
> >All data looks fine, but only every 1000th blob get
> >imported, the first one in the cache.
> >
> >Changing mod(count,1000) to mod(count,1) it works fine
> >but defeats the purpose.
> >
> >Any Ideas
> >
> >Best Regards
> >Hans
> >
> >
> >To unsubscribe from this group, send an email to:
> >ib-support-unsubscribe@egroups.com
> >
> >
> >
> >Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
> All for Open and Open for All
> InterBase Developer Initiative ยท http://www.interbase2000.org
> _______________________________________________________
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/