GetRows 1

[guitardave78]

I have been using getrows for a while now, but just wanted to know what benefit this has?

}...the bane of my life!

http://www.fuzzyd.co.uk

 

[Tarwn]

Using GetRows is usually the first or second step to speeding up processing of recordsets. From past benchmarks we determined that just changing from the recordset to the array GetRows returns you get a 7-11 times faster execution time.
Plus it's an array, so you have some capabilities that you wouldn't with a recordset (like looping through the column values rather than the row values). The minus is you lose the extended field information, like field names, types, sizes, etc. However there is nothing keeping you from pulling that info out before you .GetRows() then use .GetRows() forthe intensive parts.

Sorry, I probably answered your question by the second line

 

[guitardave78]

No was interesting, I am looking at ways of speeding up some recordset stuff. So far I have done the efficient select statment and the getRows. Anything else i need to look at?

}...the bane of my life!

http://www.fuzzyd.co.uk

 

[kaht]

Anything else i need to look at?

Static webpages, they are super fast.








That's a joke BTW.

-kaht

Looking for a puppy?

[small]Silky Terriers are small, relatively odorless dogs that shed no fur and make great indoor pets.[/small]

 

[Chopstik]

Static webpages, they are super fast.

<tongue in cheek> Funny, my page with a bunch of large picture files seems to be taking a long time to load... I must be doing something wrong... </tongue still firmly in cheek>

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill

 

[kaht]

Sounds like it's finally time for you to get rid of your 2800 bps modem Chopstik.

-kaht

Looking for a puppy?

[small]Silky Terriers are small, relatively odorless dogs that shed no fur and make great indoor pets.[/small]

 

[Tarwn]

AH HA!
I have been looking for this thread (and the one like it that was longer) for months. Here you go: thread333-132705

The longer one had better conversations, but I think they both had asbout the samne information.

 

[Chopstik]

Thanks for that, Tarwn!

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill