On Jan 16, 2007, at 11:32 AM, Tim Jones wrote:
On Jan 15, 2007, at 5:04 PM, Tim Jones wrote:
Hi Folks,
I've stumbled my way through the setup of a REALSQL database and
all seems to be working --- except that it's slow as molasses in
January (in the Northern hemisphere :) ) while importing a large
flat text file.
I have a text file that contains approximately 120K lines that are
separated by vertical bar symbols (pipes - | ). I parse the data
out of each line using NthField. The result is over 45 minutes to
parse the flat file into two datatables on a G5 1.8GHz. Any
thoughts to speed this up? The relevant code is below:
No REALSQL Performance fans out there?
I've even taken this further worrying that the NthField
manipulation might be the issue and changed the line parsing to use
an array and the Split command, but the time is the same implying
that the issue is in the actual commit of the data to the database.
Have you tried removing the DB code to see what the difference in
speed is? That sounds like unbelievably terrible performance.
Kevin
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
