Posted 20 years ago
by shark92651

I have found what I think to be a severe performance degradation when a large number of span indicators is used. For example, if I have a SQL file in the editor that is around 5 meg in size, 48,000 lines, and if I create somewhere in the number of 40,000 span indicators (will explain WHY below), then it can take around 90 seconds just to insert a Return near the top of the file. I assume the reason it takes so long is that the control has to update the offsets off all the indicators below the insertion point. Can anything be done to increase the speed of this update? Creating the 40,000 span indicators does not take nearly as long as updating them.
The reason I have so many span indicators is that I am creating one for each SQL statement in the script. If the script contains thousands of INSERT statements, then there is the problem. I can improve things on my end by only creating span indicators for certain statements, but my request for a performance improvement when updating span indicator offsets would still be welcomed.
The reason I have so many span indicators is that I am creating one for each SQL statement in the script. If the script contains thousands of INSERT statements, then there is the problem. I can improve things on my end by only creating span indicators for certain statements, but my request for a performance improvement when updating span indicator offsets would still be welcomed.