.. I'd be really suspect that there's something wrong, but I'd have to see
the code to make any really intelligent comments about it... On cf5 you
might want to build yourself a rudimentary progress bar that outputs a
little bit of the data from the current record being updated, so you can see
that it's moving forward. You can do this using some fairly simple
javascript and <cfflush>
<form><textarea></textarea></form>
<cfloop ...>
<script language="javascript">
document.forms[0].elements[0].value =
"#jsstringformat(myprogressvariable)#";
</script><cfflush>
</cfloop>
hth
Isaac
Certified Advanced ColdFusion 5 Developer
www.turnkey.to
954-776-0046
> 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?sideb
> ar=lists&body=lists/cf_talk
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> This list and all House of Fusion resources hosted by
> CFHosting.com. The place for dependable ColdFusion
> Hosting.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
