Just to add to the tips out there. Yes dumping a set of records into a QoQ is great but it will decline with larger and larger datasets. The JVM heap will only take so much. If you're using SQL Server or Oracle and have thousands of records or more. The one thing I see people forget or simply not know about is to properly index your tables. Not properly indexing your tables can result in high disk I/O as the queries will require full table scans to determine the results of your query. Proper indexing will result in less I/O and far quicker results. For stats on this, SSMS as an "Execution Plan" button that shows you the stats on a query statement. You're are allow only one cluster index per table, but you can have more than one uncluster index. Typically your primary key will be a cluster index, but that may not be the best strategy. Depending on your "where" statements you may want another column to be cluster. Also columns that are used a lot in your "where" statements should be in many cases uncluster/index. There are plenty of references on this on the net.
John Mason [EMAIL PROTECTED] 770.337.8363 www.FusionLink.com - ColdFusion and Flex hosting Now offering VPS Plans running with VMware technology Now offering ColdFusion 8 Enterprise hosting FREE Subversion hosting _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shane Heasley Sent: Friday, April 18, 2008 4:51 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] QoQ question General defense of QofQ: Keep in mind the main strength it has - which is it resides in memory. So you can pull the main data with one SQL statement and then play with it all you want using QofQ's which saves trips to the database and is MUCH faster when dealing with large numbers of records. Shane Heasley www.CTek-Media.com 307-751-3553 <http://www.linkedin.com/in/shaneheasley> View Shane Heasley's profile on LinkedIn ------------------------------------------------------------- Annual Sponsor - Figleaf Software <http://www.figleaf.com> To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
