I generally cache all the select queries to speed up the pagination, I clear that cache when any inserts/updates are done.
For BIG tables I require a search criteria to be used to reduce the number of returned records. Usually there is no reasons to page through ALL records. Snake -----Original Message----- From: Denny Valliant [mailto:[EMAIL PROTECTED] Sent: 07 August 2006 03:01 To: CF-Talk Subject: Re: CRUD On 8/6/06, Kevin Roche <[EMAIL PROTECTED]> wrote: > > Chad, > > Reactor only creates CFCs that do the standard J2EE like CRUD model > (DAO, Gateway, Active Record), which you can call from your own > display and edit pages, > > Model-Glue (version 2.0 of which incoporates reactor) will also create > display and edit pages for you. > > Kevin For a long time I've used basicly what amounts to a custom cfinsert. I like it because it's a simple: <cfset theRecord = saveToTable('form','tablename')>, does cfqueryparam, length checking, etc. Just have to match struct key names to column names. I take a hit with an initial query for table structure, but it saves so much coding time, it's well worth it (IMHO). Updates or Adds, whoopie! :-) After looking at model glue 2, and the xsl scaffolding stuff, along with reactor, I'm liking the possibilities. (I wonder if there are any cross language frameworks, with similar functionality?) I generally use queries where hip people are using gateways and stuff, so I've always wondered about paginating queries using cfoutput and startrow, maxrows. Is it a waste to query the database for a 1000 records, but only use 20 of them? Hmmm... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249029 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
