need suggestion for avoiding saving into temp tables

Question

0.00/5 (No votes)

See more:

i have a form before final save into database .
i need to insert multiple rows in to Temp table then i have to move to final table in final save .
by that performance of my web application is getting slow for every insert my appication is going to server and again grid is binding .
how can i avoid this time any fast saving method or any way to avoid temp table saving.

inserting mutiple rows means Example
a journel Voucher 1st 10rs tea one entry, 2nd 50 Rs sancks 3rd 500Rs for maintance charges.
i need to save all these thre entries under single voucher No.
so am inserting into temp table then finanlly saving into transation table.

thanks
karthik

Posted 16-Sep-11 2:13am

karthikkushala

Updated 16-Sep-11 18:25pm

v2

Add a Solution

Comments

Tejas Vaishnav 17-Sep-11 6:20am

If you like my ans then rate it...

3 solutions

Solution 1

Why insert multiple rows to a temp table - a single insert can have do more than one row. The best might be to use UNION ALL: http://blog.sqlauthority.com/2007/06/08/sql-server-insert-multiple-records-using-one-insert-statement-use-of-union-all/[^] and do it to your main table directly.

Posted 16-Sep-11 2:30am

OriginalGriff

Comments

karthikkushala 17-Sep-11 0:19am

sorry you understood wrongly ,
inserting mutiple rows means Example
a journel Voucher 1st 10rs tea one entry, 2nd 50 Rs sancks 3rd 500Rs for maintance charges.

i need to save all these thre entries under single voucher No.
so am inserting into temp table then finanlly saving into transation table.

OriginalGriff 17-Sep-11 3:50am

So you want to make sure that all three insert, or all three fail?
So use a Transaction instead. Begin Trans at the start, Commit at the end. No changes go to the live DB until you Commit - any failure, and you Rollback instead.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tejas Vaishnav · Accepted Answer · 2011-09-16T18:56:00

Try this..

1) If Windows Application then
Declare a static ado.net data table that will hold your data while you fire your insert query it will directly inserted in that table other then of the sqlservers table..

then when you want to finalize your transactions at that time you have to call the insert query of sqlserver to insert data from that static data table to database table.

2) If Web application then

create a data table as describe as above, then create a session that will hold that table for you..
at the end you need to insert that records from that session data table to your db.

Benefit of using Data Table/Data set
1) its a in memory representation so it is faster then database table
2) you can perform all operation like database table will perform
3) faster response

Kishore Jangid · Accepted Answer · 2011-09-16T19:09:00

Solution 3

Good way to remove temp tables is use complex queries by combing multiple table or use views...

even you can create a DataTable in your webpage so that travelsal from Web Page to Database is reduced.............

Posted 16-Sep-11 19:09pm

Kishore Jangid