General discussion

Locked

Query executes faster in grid mode than

By a_adie ·
Hello,everyone!!

There is a query which when executed in the grid mode(ctrl+d) takes approx 0.02 seconds(about 21,000
rows) But when I execute in the text mode, it takes about 0.40 seconds!!
Why is this difference?
Also, when the recordsfrom this table are read from a VB application, they are equally slow (as in the text mode!)
Why is it so slow on the text mode & relatively faster in the grid mode?
Has anyone got any idea on ‘Firehose’ style cursor ?(which may speedup access of data in the VB application)

Rgds,
Adie

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Query executes faster in grid mode than

by lockysmith In reply to Query executes faster in ...

Grid mode needs less memory than text mode.
Text mode allocate additional memory for trailing and leading spaces for alignment in result view. Difference can be viewed by "Task manager" on "processes" tab.
in some cases, when fetching large resultfrom from a server, SQL Analyzer use paged memory.An Disk IO operations takes a lot of time.

Collapse -

Query executes faster in grid mode than

by a_adie In reply to Query executes faster in ...

The question was auto-closed by TechRepublic

Collapse -

Query executes faster in grid mode than

by PrinterManager In reply to Query executes faster in ...

It?s old you should re-post.

Collapse -

Query executes faster in grid mode than

by a_adie In reply to Query executes faster in ...

The question was auto-closed by TechRepublic

Collapse -

Query executes faster in grid mode than

by a_adie In reply to Query executes faster in ...

This question was auto closed due to inactivity

Back to Networks Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums