I think all the time is in the UNION statement because running these queries without the union I get about 23ms to run the whole page. The test server I am running this on is local SATA with the Server (witch I have not tested this on yet) is Raid 1.
-----Original Message----- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 1:15 PM To: CF-Talk Subject: RE: table union Hmmm, 4000 records really isn't that much-- even for Access. I can't imagine it taking 30 seconds to only retrieve 4000 rows. Maybe someone with some more Access database work can speak up here. Have you tried the compact and repair option in case the database file has gotten extremely fragmented? What kind of server is your database running on? Local IDE drives? Network SCSI RAID? ~Brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289134 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
