123 reputation
5
bio website
location Darlington, United Kingdom
age 50
visits member for 3 years, 9 months
seen Jun 13 at 7:32

I started off programming in BBC Basic and 6502 assembler. I got my first job programming in FORTRAN on VMS, and since then have picked up C, C++ and SQL on VMS and Unix, with excursions into VB and IBM 360 assembler.

I drink real ale, play wargames and contract bridge, and walk in the country.

And, yes, I have a beard.


Sep
24
awarded  Autobiographer
Apr
26
awarded  Scholar
Apr
26
accepted Insert performance progressively deteriorating for indexless table
Apr
25
comment Insert performance progressively deteriorating for indexless table
@JonSeigel, I've managed to solve the problem by gathering up the insert statements into a long string and executing the result with .Execute every so soften. Doing the equivalent with LINQ didn't work. So if you want to turn your comment into an answer I'll tick it.
Apr
22
comment Insert performance progressively deteriorating for indexless table
@JonSeigel, Thanks for the suggestion, but the rows are being inserted every few seconds over a long run; we need to get the results out during the run (can't wait until the end).
Apr
19
comment Insert performance progressively deteriorating for indexless table
@StrayCatDBA, on the order of 40,000 rows on my test system.
Apr
19
revised Insert performance progressively deteriorating for indexless table
added 67 characters in body
Apr
15
awarded  Editor
Apr
15
revised Insert performance progressively deteriorating for indexless table
added 532 characters in body
Apr
5
awarded  Student
Apr
4
comment Insert performance progressively deteriorating for indexless table
@FilipDeVos, Righto. I'll try that.
Apr
4
comment Insert performance progressively deteriorating for indexless table
@Filip, yes it is, just as it came out of the tin.
Apr
4
comment Insert performance progressively deteriorating for indexless table
@usr, yes, performance does increase at the start of subsequent runs (on the same table, inserting new rows). I'll try an insert in SSMS anyway and see what I can find.
Apr
4
comment Insert performance progressively deteriorating for indexless table
@usr, thanks for your reply; I can't post any code, sadly. The insert statements are formed up in string variables and executed using database_connection.Execute(command_string). I don't have SQL Profiler and it can take months for even free software to be installed at this site.
Apr
4
asked Insert performance progressively deteriorating for indexless table
Aug
23
awarded  Supporter