Speed of snapshot vs. dynaset vs. forwardonly 
Author Message
 Speed of snapshot vs. dynaset vs. forwardonly
I know that MS says to always use the "minimum" recordset that is necessary,
but everytime I benchmark the performance of these things, the dynaset is
always the fastest.  The forward only is always the slowest.

Has anyone noticed similar?  Or complete opposite?



Sun, 06 Jan 2002 03:00:00 GMT
 Speed of snapshot vs. dynaset vs. forwardonly

Hard to say, since you don't provide any details about your benchmark. Is
this the time to connect and retrieve the first record, or the time to
access all records?

In general, there is no such thing as a "fastest" recordset, since it will
depend on a great many factors. These factors include whether the recordset
is large or small, whether it is local or accessed accross a network,
whether it comes from a server such as Oracle or is Jet recordset, etc. etc.
Even the recordset that is fastest on one machine may not be the fastest on
another running the same program, if there are substantial differences in
physical RAM.



Quote:
> I know that MS says to always use the "minimum" recordset that is
necessary,
> but everytime I benchmark the performance of these things, the dynaset is
> always the fastest.  The forward only is always the slowest.

> Has anyone noticed similar?  Or complete opposite?



Sun, 06 Jan 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Q: Opening recordset with forwardOnly, dynaset, or snapshot options

2. TTable vs TQuery vs TwwQuery vs TwwTable - SPEED

3. DYNASET vs SNAPSHOT

4. Dynaset vs Snapshot + Jet Engine included ?

5. Speed of moving thru dynaset (or snapshot)

6. Access vs Approach vs Paradox vs FilePro vs Filemaker Pro

7. forwardOnly recordset slower than dynaset for large tables?

8. Snapshot.base.tar.gz vs Snapshot.tar.gz

9. Access speed Vs MS Sql Speed

10. Access vs SQL Server vs Sybase vs Oracle

11. Oracle vs SQL Server vs Informix vs Sybase

12. HELP Paradox vs Access vs Foxpro vs ????????????


 
Powered by phpBB® Forum Software