This question is locked. New answers and comments are not allowed.
Hello
I seem to have a problem regardig inserting 10000 records in a sql server table with 150 columns. The cpu load is 100% and not dropping during the insert. The duration of the insert is about 20 sec.(both first and second time) However if insert 10000 records in af table with only 4 columns, the duration is acceptable 3-4 seconds.
(Inserting 10000 records with query analyzer takes 2 sec in both cases)
The application is written in asp.net 3.5, sql server 2005 and openaccess.
Any Ideas what´s wrong?
/Ivan
I seem to have a problem regardig inserting 10000 records in a sql server table with 150 columns. The cpu load is 100% and not dropping during the insert. The duration of the insert is about 20 sec.(both first and second time) However if insert 10000 records in af table with only 4 columns, the duration is acceptable 3-4 seconds.
(Inserting 10000 records with query analyzer takes 2 sec in both cases)
The application is written in asp.net 3.5, sql server 2005 and openaccess.
Any Ideas what´s wrong?
/Ivan
3 Answers, 1 is accepted
0
Hi Ivan,
I reproduced the effect to some extent, but we need to analyze it a bit further. I've already identified a place where more work was done than needed; that fix will be contained in the next version.
I would like to know if there is a special pattern present in your case.
Which types do the fields have? How are they mapped?
Regards,
Thomas
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
I reproduced the effect to some extent, but we need to analyze it a bit further. I've already identified a place where more work was done than needed; that fix will be contained in the next version.
I would like to know if there is a special pattern present in your case.
Which types do the fields have? How are they mapped?
Regards,
Thomas
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Ivan
Top achievements
Rank 1
Rank 1
answered on 09 Feb 2009, 07:55 AM
Hi Thomas
Well actually we now only have 93 columns in the table but the poor results are the same. The Fields are mostly of type string, few of int, money and decimal. The columns are mapped to fields by the wizard- very straight forward.
Thanks
Ivan
Well actually we now only have 93 columns in the table but the poor results are the same. The Fields are mostly of type string, few of int, money and decimal. The columns are mapped to fields by the wizard- very straight forward.
Thanks
Ivan
0
Hello Ivan,
I've looked into this and made some changes that will improve the performance noticeably. Don't expect miracles however, as we still need to process based on meta data, and a pure ADO program will usually not take this into account.
The next version will contain the changes.
Kind regards,
Thomas
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
I've looked into this and made some changes that will improve the performance noticeably. Don't expect miracles however, as we still need to process based on meta data, and a pure ADO program will usually not take this into account.
The next version will contain the changes.
Kind regards,
Thomas
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.