I'm in the final stages of optimising some pre-existing data processing code. A big chunk of the optimisation has been achieved by converting the code to use GetRows() and arrays rather than the recordset object to loop through data. So far so good, lots of performance improvement and everything was going well.
However I am having a problem which I'm having trouble pinning down. Here's the situation. The existing code creates a recordset from a simple select query (against access 2K). Then it loops through a given number of times and filters the recordset at the beginning of the loop before processing the data. I've converted this over to GetRows() but the filtering is done on the recordset before GetRows() is called. I assumed that applying a filter to a recordset and calling GetRows() would result in only the filtered data being returned in the array. Is this the case, or will GetRows()return every record in the recordset? Any help would be appreciated... it's Monday morning, you know the story! Lol Dan www.diado.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
