Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
Abs0 #1
Multiple DB Insert
I have an XML file that has roughly 55,000 records. I need to parse the
contents of the file and store it in a database. The problem I'm having is
that doing 55,000 inserts every hours will really cripple the server I'm using.
I was wondering if anyone knew of a way for me to create the queries, or store
up the variables, and do one insert at the end that updates or inserts multiple
records. Any enlightment on this subject would be immensely appreciated.
Abs0 Guest
-
insert multiple row
How do i insert multiple rows in database. for example: I have 3 list: list1: a1,a2,a3,a4 list2: b1,b2,b3,b4 list3: c1,c2,c3,c4 I want to... -
insert multiple row and table
I have table1 and table 2, one to many relationship. How do I save 3 rows in table 1 and one row in table 2 at the same time? -
Multiple Insert or Looping Insert
I built an application on an Access DB that allows a dispatcher to log trucks in the field at their location as they call in. There are three... -
Insert Multiple INTO multiple table
Is there an extension available that can insert into multiple database tables and then retrieve the ID of the first insert? Andy -
multiple insert problem !
hi ! had to come right back... this time i'm trying to do a multiple insert. in my admin website i want to add users to a specific project. i... -
jorgepino #2 Re: Multiple DB Insert
you could import them right into the data base. wiht out having to use CF
jorgepino Guest
-
Abs0 #3 Re: Multiple DB Insert
The problem is, it's a dynamic file that I have to re-parse every hour. I'm going to setup a scheduled task to run the script every hour but don't want to tap out a CPU every hour in the process.
Abs0 Guest
-
-
jorgepino #5 Re: Multiple DB Insert
what database are you using?
for MSsql here is some info
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/anch_SQLXML.asp[/url]
jorgepino Guest
-
Abs0 #6 Re: Multiple DB Insert
Yes, it's 55,000 records every hour into a MS SQL Server db.
Abs0 Guest
-
jorgepino #7 Re: Multiple DB Insert
I would still make Mssql do the upload with T-sql
jorgepino Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
