hehehe - i got confused for a minute there - i'm talking about the GetString method,
not the GetRows method.  I dont have any experience with the GetRows method.

sorry for the mess.

(i need sleep)

john

--- John Pirkey <mailjohnny101@y...> wrote:
> 
> i did a small test once on this very thing.  i wanted to know, why so many people
> said that i should use getrows and pass the required parameters, to build an HTML
> table from a recordset (this was obviously in an ASP app).  So i did it both ways,
> on two different pages, in two different sessions.  It's hard to say with complete
> accuracy, but it sure seemed to me (more than once), that looping through the
> recordset - building a string of HTML - was faster than calling the .GetRows
> method
> -once.  This could have been due to outside influences, but i did it several
> times,
> on different days to make sure nothing was cached and it was the same every time -
> the loop page was displayed sooner.  the HTML was virtually identical, so i dont
> think it was a browser issue.
> 
> just a couple of thoughts,
> 
> john
> 
> --- Christopher Tacke <ctacke@r...> wrote:
> > But then what is the performace hit for GetRows()?  It must build the array
> > and populate it, which is going to take memory (which checking for EOF
> > doesn't require) and plenty of cycles to accomplish.
> > 
> > Just another example of many ways to achieve the same task, I guess.  I'd
> > like to know what the performance hit, if any, for using EOF is.
> > 
> > 
> > 
> > ------------------------------------------
> > Christopher Tacke, MCSD
> > Rubicon Technologies
> >  (xxx)xxx-xxxx