Re: SQL slowing down

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ralph Krausse (gordingin_at_consiliumsoft-nospam.com)
Date: 06/21/04 

Date: Mon, 21 Jun 2004 11:33:42 -0400

Thanks for the reply Uri. But I am a BIG novice when it comes to SQL. I am
reading up on it but don't see, well I should say, don't understand how that
code can help? Does this somehow queue up 1000 records in some temp table
before I do my insert? what is CHECKPOINT? Could you maybe explain a bit
more. I guess what I would like to know if there is a way to queue up data
in SQL before the insert serializes to the DB..

Thanks
Ralph

"Uri Dimant" <urid@iscar.co.il> wrote in message
news:Og4Aq64VEHA.3512@TK2MSFTNGP12.phx.gbl...
> Ralph
> I would go with to divide one big INSERT into small transactions.
> SET ROWCOUNT 1000
> WHILE 1 = 1
> BEGIN
> ------Perfom here your INSERTION
> IF @@ROWCOUNT = 0
> BEGIN
> BREAK
> END
> ELSE
> BEGIN
> CHECKPOINT
> END
> END
>
> SET ROWCOUNT 0
>
>
>
> "Ralph Krausse" <gordingin@consiliumsoft-nospam.com> wrote in message
> news:Ol9s024VEHA.644@tk2msftngp13.phx.gbl...
> > I have an application that uses COM to do simple INSERTS into SQL. The
> data
> > is received from about 4,000 client passed over the Internet. When I
start
> > my app, everthing works well but as the database grows, my clients start
> to
> > time out because the information takes longer to write to the DB.
> > Is there a way to do a insert of a lot of data. I wrote my application
so
> I
> > could queue up information in memory, thinking that I just shove a ton
of
> > info to SQL instead of doing 20 INSERT per second, which is about what
is
> > needs to do.
> >
> >
> > Thanks
> > Ralph Krausse
> > www.consiliumsoft.com
> > Use the START button? Then you need CSFastRunII...
> > A new kind of application launcher integrated in the taskbar!
> > ScreenShot - http://www.consiliumsoft.com/ScreenShot.jpg
> >
> >
>
>

Quantcast