On 9 Sep 98, at 1:12, Bruce Young wrote:
> Hi Ivan
> Thanks for your reply.
> 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.
Well I'll try to be more precise. Let me know if you need this info
NOW or I have a couple of day so I can send the EXACT actual
dimension and the format of the TXT converted and the time it
takes and if I can continue to use the DB while the new DB is
being converted.
> >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
Mumble... 130Mb at a rate of 1.7Mb /sec= 1.3 minutes at a rate of
3Mb/sec=45 sec... here in italy 128Mb of RAM cost about 170$ :-)
I think MS SQL will cost MORE.
This solution may seem idiot but maybe it's not.
> 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.
I'll give a look to our ASP source code to understand if it's well
written, how it succeed to convert from txt to SQL etc...
But it seem that CF is doing a better work than MS SQL since you
obtain results in 2-3 mins while we get result in 5 with a steroidized
machine... anyway I'll check because in this case the difference
between 3min and 5 min could be relevant for you.
> >That is all I can say.
> And thanks for saying it. :)
Well I'm really a newbie with DB and Internet (less than 2
months)... I've started using internet less than 2 years ago. I've
been a web designer/consultants for about 1 year and a half.
I'm al little bit shy :-) This list is frequented by veterans...
"Ubergruppen Fuhrer"... fortunately I don't have "Ubergruppen
Fuhrer" so I can laugh behind your shoulder ;-)
-------------------------------------------
Ivan Sergio Borgonovo [EMAIL PROTECTED]
Webmaster Gorilla Bookstore http://www.gorilla.it
Tel. +39 2 3311105/34530455 Fax. +39 2 34531591
Via Mac Mahon 9, Milano, Italy
-------------------------------------------
____________________________________________________________________
--------------------------------------------------------------------
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.
---------------------------------------------------------------------
