Hi all,
I have an old, ugly and large Paradox database that I inherited and am converting
into a new, beautiful and large SQL Server (7) driven schema.
Problem is the importing of this old database - it takes a VERY long time and i
have to watch it like a hawk because invariably the Paradox data is broken beyond
belief in places and I have to fix the data or scrap that row or work around it...
The reason it takes so long (it's not to do with Paradox itself, those queries get
cached), is that the inserting of this data generates, about 500 insert queries per
row of data in the old paradox database (it was a big flat file thing more or less, my
schema is fully relational), there are just under 1000 rows, that's, 500000 inserts !
Not to mention the fact that the SQL server is all the way across the net :-)
So, is there any way to do a BULK insert into single tables aside from using "BULK
INSERT" itself, which inserts from a file on the SQL server (I don't have access to
put files on the SQL server anyway), so that instead of 500 individual inserts per old
database row I can just do one insert for each of my new tables (that is insert all
the "Education" data for a row in one shot, insert all the "Staff" data in one shot
etc) there by reducing the load to maybe 40 "bulk" inserts per row, and the total down
to 40000 "bulk" inserts (which is still a lot, but not staggeringly).
Ideas anybody ?
---
James Sleeman
Innovative Media Ltd
Ph: (03) 377 6262
http://www.websolutions.co.nz
CAUTION: The information contained in this email message is confidential and may be
legally privileged. If the reader of this message is not the intended recipient you
are notified that any use, dissemination, distribution or reproduction of this message
is prohibited. If you have received this message in error please notify the sender
immediately and destroy the original message and any attachments.
Views expressed in this communication may not be those of Innovative Media Ltd.
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
