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

Problems with large commented texts

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

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.

Thanks

Ésio

Comments

  • 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.


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