Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saran1086
Starting Member
4 Posts |
 Posted - 2008-11-14 : 08:16:55
|
| Hey guyz!I have a problem while uploading files into database ;the system or processor becoming slower which is killing my time.Mostly the files are of (.csv)formats.Can any one help me with a solution which makes my things better and faster.I thought of compressing techniques but the contents will be altered and need an extractor at server side to store into database.Help me with a good solution!!! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-14 : 12:49:56
|
| Its because of indexes. |
 |
|
|
saran1086
Starting Member
4 Posts |
Posted - 2008-11-17 : 02:31:04
|
| I want a solution for ploading the files fastly without wasting time |
|
|
|
saran1086
Starting Member
4 Posts |
Posted - 2008-11-17 : 02:31:46
|
| Will u please help me!!! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-17 : 02:47:58
|
| Try using BULKINSERT for uploading files into db. |
|
|
|
saran1086
Starting Member
4 Posts |
Posted - 2008-11-17 : 06:38:10
|
| Will u please tell me what is BULKINSERT |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-17 : 06:41:09
|
| Remove indexes,load with Bulk insert or Export/Import Wizard(See Books online,reapply index when you are done. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-17 : 09:56:02
|
quote:
Originally posted by saran1086
Will u please tell me what is BULKINSERT
books online should be your first search placehttp://msdn.microsoft.com/en-us/library/ms188365(SQL.90).aspx |
|
|
|
|
|
|
uploading files into database...