[AccessD] SQL against recordset

Thanks Gustav,

I did not see that post.  I will definetely take a look at it.

Thanks,

Mark


>From: "Gustav Brock" <Gustav at cactus.dk>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: <accessd at databaseadvisors.com>
>Subject: Re: [AccessD] SQL against recordset
>Date: Wed, 19 Sep 2007 11:42:41 +0200
>
>Hi Mark
>
>Did you read the post from Shamil:
>
>"The Baker's Dozen: A 13-Step Crash Course for Using LINQ":
>
><quote>
>
>LINQ is a set of extensions to the .NET Framework to query different types 
>of data using a common language. Orcas Beta 1 features the following LINQ 
>capabilities within .NET:
>
>Querying Microsoft SQL Server data using a strongly-typed DataContext (LINQ 
>to SQL)
>Querying in-memory .NET objects (LINQ to Objects)
>Querying .NET DataSets (LINQ to DataSets)
>Querying XML Data (LINQ to XML)
>
></quote>
>
>Using LINQ with a DataSet might be faster than your current solution.
>
>/gustav
>
> >>> markamatte at hotmail.com 18-09-2007 16:29 >>>
>The Recordset was retrieved from the (local) Access database...and as a
>snapshot, it was only twice as slow...so far...unless I'm doing something
>way off here...running 10K SQL statements seems to be fastest...but I'm
>having a hard time accepting that.
>
>Thanks,
>
>Mark A. Matte
>
>
> >From: "Gustav Brock" <Gustav at cactus.dk>
> >Reply-To: Access Developers discussion and problem
> >solving<accessd at databaseadvisors.com>
> >To: <accessd at databaseadvisors.com>
> >Subject: Re: [AccessD] SQL against recordset
> >Date: Tue, 18 Sep 2007 11:17:53 +0200
> >
> >Hi Mark
> >
> >Oh, but the recordset, was that retrieved from SQL Server or a (local)
> >Access database?
> >Did you try to open it static and/or as a snapshot?
> >
> >/gustav
> >
> > >>> markamatte at hotmail.com 18-09-2007 04:24 >>>
> >Hello All,
> >
> >I tried the suggestion below...using 10k filters instead of 10K SQL
> >statements...it actually took 3 times as long.
> >
> >I need the fastest approach to executing 10K SQL Statements/Sets of
> >Criteria.
> >
> >The 10K are all againts the same 3K row table.
> >
> >Any ideas?>
> >
> >Thanks,
> >
> >Mark A. Matte
> >
> >
> > >From: "Gustav Brock" <Gustav at cactus.dk>
> > >Reply-To: Access Developers discussion and problem
> > >solving<accessd at databaseadvisors.com>
> > >To: <accessd at databaseadvisors.com>
> > >Subject: Re: [AccessD] SQL against recordset
> > >Date: Tue, 04 Sep 2007 16:30:10 +0200
> > >
> > >Hi Mark
> > >
> > >To initiate an SQL Execute is slow. Running DAO on a recordset is very
> > >fast, indeed when you have only 3K records.
> > >So open a recordset and apply the 10K filters - my guess is a 10 fold 
>speed
> > >increase or more.
> > >
> > >/gustav
> > >
> > > >>> markamatte at hotmail.com 04-09-2007 16:12 >>>
> > >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
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Test your celebrity IQ.  Play Red Carpet Reveal and earn great prizes! 
http://club.live.com/red_carpet_reveal.aspx?icid=redcarpet_hotmailtextlink2