Re: Is CFGRID in CF9 solid enough for heavy use for CRUD functionality?
I tell everyone that the cfajax tags are great for rapid prototyping, but it's best to go straight ExtJs for production implementation on anything but the simplest work. One of the biggest issues I've seen, in examples of paging with the cfgrid tags, is the use of the QueryConvertForGrid() method for creating your paged datasets. If performance is an issue, you will be much better served by writing a true paging query. The QueryConvertForGrid() method is basically taking on a QueryOfQuery approach, whereby your querying your entire recordset and filtering it down at the CF level before passing it to the grid. For large datasets, this is handled much better at your SQL tier. There are many examples on this out on the web. It's fairly trivial with MS SQL, and really easy with MySQL. Steve "Cutter" Blades Adobe Community Professional - ColdFusion Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of "Learning Ext JS" http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Steve "Cutter" Blades Adobe Community Professional - ColdFusion Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of "Learning Ext JS" http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Eric . wrote: > Playing with some CFGRID examples on ColdFusion 9, I noticed some major > slowdown without a lot of records being loaded. Being on a locally hosted > server off my workstation that concerned me even more. > > I have a lot of CRUD pages for various parts of a management system we're > re-writing as a Software-as-a-Service app that would be great candidates for > a CFC that creates a CFGRID (or something similar) with dynamic functionality. > > However playing with my examples, I worry about real-world use and larger > datasets making them judge our app for something that isn't its fault. > > > Currently I follow the old tried and true model of an HTML table that > displays data, a link to edit that goes to a form, etc. Inline editing would > work great for a lot of these screens, so a grid-based format seems ideal. > > > Has anyone had any great success with moving away from the old-school > approach to something a little more modern? > > I'm on a dual-core box with 2 gigs of ram, which might be a tad higher than > I'd expect from our users. I'm looking for something that does what I need > it to do but without that "clunky" feeling. > > > Am I just not customizing CFGRID well enough, or am I on to something you've > realized as well? > > TIA :) > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333506 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is CFGRID in CF9 solid enough for heavy use for CRUD functionality?
On Fri, May 7, 2010 at 11:27 AM, Will Tomlinson wrote: > >> Playing with some CFGRID examples on ColdFusion 9, I noticed some >> major slowdown without a lot of records being loaded. Being on a >> locally hosted server off my workstation that concerned me even more. > > > I like jqGrid. cfgrid bit me in the butt when I moved to Railo. jqGrid fixes > that problem. > > http://www.trirand.com/jqgridwiki/doku.php?id=start +1 for not actually using cfgrid. :) I like dojo's grids/data binding stuff. Here's an example of a cool one: http://www.dojotoolkit.org/reference-guide/dojox/grid/EnhancedGrid.html Awesome stuff. The demos that come with the source work better than the online ones, I don't think they update those demos much. They're trying to keep the goodness hidden, for some reason. But don't let that fool you, it's *powerful* stuff :) :Den -- What every genuine philosopher (every genuine man, in fact) craves most is praise although the philosophers generally call it recognition! William Jame ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333499 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is CFGRID in CF9 solid enough for heavy use for CRUD functionality?
> Playing with some CFGRID examples on ColdFusion 9, I noticed some > major slowdown without a lot of records being loaded. Being on a > locally hosted server off my workstation that concerned me even more. I like jqGrid. cfgrid bit me in the butt when I moved to Railo. jqGrid fixes that problem. http://www.trirand.com/jqgridwiki/doku.php?id=start Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333490 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is CFGRID in CF9 solid enough for heavy use for CRUD functionality?
Thanks Dan, Do you have any specific links that you've come across and deemed authoritative for some of those techniques? There's a lot of CFGRID examples but some lead to broken javascript errors in IE or other buggy functionality. > On Thu, May 6, 2010 at 5:10 PM, Eric . wrote: ... > > > Am I just not customizing CFGRID well enough, or am I on to > something you've realized as well? > > I don't know about cfgrid specifically, but the principal is sound, > and works, and there are tricks to make it work better (splitting up > some stuff so it loads right away and then lazy loading other stuff, > which toolkit you roll with, etc.). > > I just *love* my scrolling grids. To heck with manual paging! > > And these grids can be blazingly fast, if that was your real question. > :) > > :Den > > -- > Time itself comes in drops. > William James ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333482 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is CFGRID in CF9 solid enough for heavy use for CRUD functionality?
On Thu, May 6, 2010 at 5:10 PM, Eric . wrote: ... > Am I just not customizing CFGRID well enough, or am I on to something you've > realized as well? I don't know about cfgrid specifically, but the principal is sound, and works, and there are tricks to make it work better (splitting up some stuff so it loads right away and then lazy loading other stuff, which toolkit you roll with, etc.). I just *love* my scrolling grids. To heck with manual paging! And these grids can be blazingly fast, if that was your real question. :) :Den -- Time itself comes in drops. William James ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333460 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Is CFGRID in CF9 solid enough for heavy use for CRUD functionality?
Playing with some CFGRID examples on ColdFusion 9, I noticed some major slowdown without a lot of records being loaded. Being on a locally hosted server off my workstation that concerned me even more. I have a lot of CRUD pages for various parts of a management system we're re-writing as a Software-as-a-Service app that would be great candidates for a CFC that creates a CFGRID (or something similar) with dynamic functionality. However playing with my examples, I worry about real-world use and larger datasets making them judge our app for something that isn't its fault. Currently I follow the old tried and true model of an HTML table that displays data, a link to edit that goes to a form, etc. Inline editing would work great for a lot of these screens, so a grid-based format seems ideal. Has anyone had any great success with moving away from the old-school approach to something a little more modern? I'm on a dual-core box with 2 gigs of ram, which might be a tad higher than I'd expect from our users. I'm looking for something that does what I need it to do but without that "clunky" feeling. Am I just not customizing CFGRID well enough, or am I on to something you've realized as well? TIA :) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333453 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm