[AccessD] SQL against recordset

This is the speed thing again.  I am running 10K SQL statements against a 3K 
row table.  I need it to be as fast as possible.  Currently my 10K 
statements are stored in a table.  I pull them in as a recordset...loop 
through...and execute each one.  The 10K are all looking at the same 
table...just different sets of criteria.  A friend suggested I pull the data 
into a recordset...and have each SQL statement reference the recorset...as 
an attempt to save time.  Maybe an array?

Any thoughts?

Thanks,

Mark A. Matte

P.S...Searching for 'stuff' like this...found an articly by Susan H. about 
arrays...but not quite what I needed.


>From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] SQL against recordset
>Date: Mon, 3 Sep 2007 20:23:05 -0700
>
>Why do you want to do this.  Or, what are you trying to accomplish?  Why 
>not
>just open a second recordset?  The criteria are the same, yes?
>
>Rocky
>
>
>
>
>
>
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
>Sent: Monday, September 03, 2007 6:26 PM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] SQL against recordset
>
>Hello All,
>
>This might sound odd...but I want to use VBA to open a recordset...
>
>"Set rst1 = dbs.OpenRecordset("SELECT symbol from tblList...."
>
>then I want to open a new recordset by running an SQL statement against the
>first recordset.  I don't know if this is possible...and if so...what 
>syntax
>would I use to reference the recordset?
>
>"Set rst2 = dbs.OpenRecordset("SELECT symbol from rst1..."???????
>
>Any thoughts?
>
>Thanks,
>
>Mark A. Matte
>
>_________________________________________________________________
>A place for moms to take a break!
>http://www.reallivemoms.com?ocid=TXT_TAGHM&loc=us
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.5.484 / Virus Database: 269.13.2/985 - Release Date: 9/2/2007
>4:32 PM
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Get the device you want, with the Hotmail® you love. 
http://www.windowsmobile.com/hotmailmobile?ocid=MobileHMTagline_1