Best way to insert data to MSDE -- sql server new users

Eli
3/30/2005 2:01:02 AM

Hello.
I'm creating a stand-alone windows application using the MSDE server.
Performance issues in this application are big-deal to my client.
I need to insert data to the database in rate of â€“ 2MB / sec.
Each insert action should insert ~ 10-40 MB to the database.

My questions are:
1. What is the fastest way to INSERT data to the database? Using insert from
c# code, scripts, stored procedure, other?
2. What is the fastest way to retrieve information from the database?

Thanks.

Fredrik Wahlgren
3/30/2005 5:37:00 PM

[quoted text, click to view]

1) Bulk Insert
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ba-bz_4fec.asp
2) Good queries
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/scalenethowto04.asp

/Fredrik

sql server new users : Best way to insert data to MSDE