ADO and Cross tab queries/Pivot

[Geir O. Hansen]

Hello
Need help to make fast(very) crosstab queries with ADO
and SQL Server 7.0(6.5)?
(21000 records in a grid(31 cols/120 rows in 1.8 seconds
on a 100 MB network With a P III/450mhz)

Geir O. Hansen
n-Tier Consulting
Geiromar@online.no

[Jason Steele]

Believe it or not, I have found that in some occasions (depending on the complexity
of the cross-tab) it is quicker to get seperate resultsets and then build
the cross-tab in code into a variant array/user created resultset/XML.

Another thing to consider if your cross tab data isn't too dynamic is to
have a timed job (in SQL Server Agent) which updates a table to be used for
you cross-tab so that you do a simple select from that table when you want
the cross-tab resultset.

Hope this helps,

Jason Steele
Norwich Union Investment Funds

"Geir O. Hansen" <geiromar@online.no> wrote:
>
>Hello
>Need help to make fast(very) crosstab queries with ADO
>and SQL Server 7.0(6.5)?
>(21000 records in a grid(31 cols/120 rows in 1.8 seconds
>on a 100 MB network With a P III/450mhz)
>
>Geir O. Hansen
>n-Tier Consulting
>Geiromar@online.no