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 |
|
sarikavbhosale
Starting Member
24 Posts |
 Posted - 2007-07-06 : 02:08:34
|
| Hi Friends,I am having one application which reads data from .mdb file and transfers it to SQl server database,because sql server databse is used for further application process.The daily data transfer is around 90 MB mdb file to sql server and it fetches it row by row and this operation takes 100% of CPU.How can i overcome this performance issue and it takes long time.Need help plz. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-07-06 : 02:11:50
|
| Why don't you use DTS to perform the data import in SQL Server rather than using custom application. It is fast, efficient and simple to use.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
sarikavbhosale
Starting Member
24 Posts |
Posted - 2007-07-06 : 02:15:22
|
| Yes that is good option,but again is VB 6.0 application ,in DTS i will use the same thing,effect will be same. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-06 : 02:40:23
|
| DTS can use a bulk import, rather than row-by-row. This should be much faster.Kristen |
|
|
|
sarikavbhosale
Starting Member
24 Posts |
Posted - 2007-07-06 : 02:45:31
|
| Ok i will try that way. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-06 : 06:50:17
|
| Look out for the option to set the Batch Size to something appropriate for the volume of records you are importing - if its only a few thousand you will probably be able to import them in a single batch.Kristen |
|
|
|
|
|
|
Sql operation increses CPU utilisation