Re: Database-less queries

2009-10-05 Thread Rick Root
On Sat, Oct 3, 2009 at 8:58 PM, Pete Ruckelshaus pruckelsh...@gmail.com wrote: Before I venture forth on this bit of experimental (for me) coding, I was wondering if anyone else has done this, and what were the results?  This is really more of a proof of concept, and would be used with a

Re: Database-less queries

2009-10-05 Thread Ian Skinner
Rick Root wrote: My experience has been that queries of queries are less efficient that actual database queries, but my experience involves larger datasets (tens of thousands of rows in the base query dataset) Just on a side note, that is the expectation of the ColdFusion engineers as well.

Re: Database-less queries

2009-10-05 Thread Pete Ruckelshaus
This is one of those little challenges that I did just to see if I could do it. Here's the result, nothing too exciting unless you play Farmville on Facebook -- http://www.ruckelshaus.com/farmville/ Thanks for the help, Pete

Re: Database-less queries

2009-10-05 Thread s. isaac dealey
This is one of those little challenges that I did just to see if I could do it. Here's the result, nothing too exciting unless you play Farmville on Facebook -- http://www.ruckelshaus.com/farmville/ Thanks for the help, Neat! I don't play any of the games on Facebook, but that's cool. I've

Database-less queries

2009-10-03 Thread Pete Ruckelshaus
There are times when I have a simple problem that calls for a simple solution. I have data that is perhaps a half dozen columns and three dozen rows; I was thinking how it would be cool to load that data somehow as a query object in a memory-resident (most likely application scope) variable,

RE: Database-less queries

2009-10-03 Thread lists
To: cf-talk Subject: Database-less queries There are times when I have a simple problem that calls for a simple solution. I have data that is perhaps a half dozen columns and three dozen rows; I was thinking how it would be cool to load that data somehow as a query object in a memory-resident

Re: Database-less queries

2009-10-03 Thread s. isaac dealey
Hey Pete, Although CacheBox is using structures for performance on fetch operations, it's using a query to store the metadata for the content in cache to improve performance of other operations like reporting statistics and bulk-expiring or bulk-reaping the cache. (Either of which are