Discussion Locked

Query executes faster in grid mode than

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

5 replies

by lockysmith

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.

This discussion is closed to new replies.