Like (I think) Isaac said, there's probably something wrong with the code,
but it's kind of hard to tell for sure without looking at the code.
I apologize if this is obvious, but since you didn't really explain the
particulars of the situation, I wanted to make sure that you weren't
inadvertently making this harder than need be. Does the situation allow for
you to update the column via a single UPDATE query as in:
UPDATE fooTable
SET barColumn = barColumn + 1
If so, this will be infinitely quicker than having to perform 1 UPDATE query
per record.
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
> -----Original Message-----
> From: Srimanta [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 07, 2002 8:47 PM
> To: CF-Talk
> Subject: Time Required for Updating DB
>
>
> Hi
> I am having trouble updating a fairly small size database with
> approx 20000
> records.
> Size in MB is approx 18 MB. Type Access 2000.
>
> I am updating one particular column, in all the rows with CF
> Query and Loop
> tags.
> First the program generates : Bad Allocation Error complaining of Virtual
> memory shortage.
> I have 256 MB Ram Windows 2000 Server Pentium III 999 MZ Processor.
>
> When I increased the Virtual memory size the update seems to be
> going on for
> ever!!!
> Its exactly 5 hours plus now its running.
> How much time does similar updates take?? Any ideas ??
> I have not done this before.
>
> Srimanta
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
