What are the challenges you face when working across database platforms? Take the survey

Problems with large commented texts

EsioNEsioN Posts: 103
edited March 23, 2007 12:56PM in SQL Prompt Previous Versions

This occurs often with me.

I run one select, getting some rows, etc, etc. and I copy that rows from result pane to command window. Then SP come extreamly slow. Of course this behavior is expected, once SP is trying parsing the row I copied.
But even is I coment this lines with /* */, the behavior occurs, even if I was editing command outsite the commented area.

I read other post in this forum about SP parsing commented lines, but this behavior is too shackler. Maybe you can create a new comment tag, or something like this, to indicate SP to ignore some texts.




  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    Hi Esio,

    Thanks for posting. We are aware of this performance issue and are aiming to fix it in the next 3.x release.

    Bart Read
    Principal Consultant
    bartread.com Ltd
Sign In or Register to comment.