Structure is more faster than query for example if you want to create a
shopping
cart, all information is saved in memory and you can add, delete, update
structures to change items and it is much faster than saving items in
database.
Cache query may be faster only for display.
At 09:38 AM 8/31/00 -0400, you wrote:
>I'd be interested in knowing what the code and data structure in your tests
>looked like... We are using structs a good deal in some apps, and I had
>been assuming it would be faster than a query.
>
>-Cameron
>
>--------------------
>Cameron Childress
>McRae Communications
>p. 770-460-7277 x.232
>f. 770-460-0963
>
> > -----Original Message-----
> > From: paul smith [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, August 31, 2000 9:06 AM
> > To: [EMAIL PROTECTED]
> > Subject: Structures No? Cached Queries Yes?
> >
> >
> > I see my earlier post was obscure to opaque.
> >
> > For the same results:
> >
> > Get data from a cached query: Average = 180ms
> > Get data from a database stored in a Structure: Average = 227ms
> >
> > Structure takes 26% longer than a cached query to get the same
> > data.
> >
> > This kind of makes sense, since with a Structure I have to run a
> > query anyway to get the list of KEYS, which I use to loop over
> > the Structure to pull only two more columns of data out of the
> > Structure.
> >
> > More tests later...
> >
> > best, paul
> >
> >
> >
> > Paul Smith
> > Web/Database Droid
> > A: SupportNet, Inc, 3871 Piedmont Ave, Oakland, CA 94611
> > P: (510) 763-2358
> > C: (510) 205-6755
> > F: (510) 763-2370
> > E: [EMAIL PROTECTED]
> > W: http://www.support.net
> >
> > ------------------------------------------------------------------
> > ------------
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
>_talk or send a message to [EMAIL PROTECTED] with
>'unsubscribe' in the body.
>
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
