>Bruce Young wrote:
>
>> The server that does this has plenty of power and RAM but it still maxes
>> out the CPU while it is converting the info from a text file to the DB
>> format. It would quite often fail on that server if I asked CF to do a
>Bruce, you did not say "how" you are getting the files from the outside
>source, but let's assume that they are text files. If so, you should
>consider using Perl on your NT with the DBI module to process the text file
>into the Access tables. It is much more efficient than having CF do it. CF
>just ain't built as a text processor.
Thanks Jack
I did mention the text file... they get sent to me each night. :) Yes, the
use of Perl to do the initial DB procesing has been suggested as that is
what Perl is good at. I've just not used a DBI module before in Perl...
which I'm revisiting after a 2 year absence to do some custom Lyris
interfacing at the moment.
>I don't think you'd gain by moving to SQL Server,
>since the problem lays in the method you are using to convert the data.
This is what I thought also. We don't really have any other problems wih
Access and while I have no real objections to going to MS SQL server, I
don't see that it would help us either.
I might also see if I can get those who do the inital export of the data to
improve the quality of what they send so I can reduce the amount of
cleaning up I have to do.
thanks again
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.
---------------------------------------------------------------------
