Hi Ivan
Thanks for your reply.
>It depends on load, transaction, number of records etc... Just
>joking...
;-)
>We have a small DB (5000 records, about 10 fields) in MS SQL
>imported weekly from a text file (3Mb). I didn't program the system
>and I didn't try to look at the DB while it is updated but the time
>required is very short (5 to 10 minutes).
Well, it's all a matter of perception... mine only takes 2-3mins but when
your sitting there watching it (with CPU at 100%) and your ""Ubergruppen
Fuhrer" is sitting there also... it can seem forever.
>There is a tool to upsize an Access DB to an SQL DB on MS
>site... it's not hard to find... give a look at MS site I think you'll find
>something interesting to read about the transition from Access to
>SQL ( http://support.microsoft.com ??).
I'll dig that out, sounds useful. Cold Fusion does suggest using the MS SQL
server.
I think my biggest problem was the CF Transaction process that made a huge
temporary file of 130mb+, filling C: drive and stuffing the server. I'm not
using it now and it seems to be much lighter on resources though I'll have
to use other, less convenient, methods to roll back from failure now.
>That is all I can say.
And thanks for saying it. :)
Bruce
____________________________________________________________________
--------------------------------------------------------------------
Join The Web Consultants Association : Register on our web site Now
Web Consultants Web Site : http://just4u.com/webconsultants
If you lose the instructions All subscription/unsubscribing can be done
directly from our website for all our lists.
---------------------------------------------------------------------
