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 -----Original Message----- From: Travis Haley [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 1:48 PM To: CF-Talk Subject: RE: table union There are 4000 entries currently and growing every check we write go's into one of the two tables. -----Original Message----- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 12:09 PM To: CF-Talk Subject: RE: table union I'm not sure about temp tables in access. If my temp table you really just mean creating a regular table which you will drop when you are done that would not allow for concurrent executions of your code since they would be using the same table. (temp tables in SQL Server are connection specific I believe) There are ways around that, like having a unique number per process, but you are kind of defeating part of you purpose at that time. How many records are you dealing with? ~Brad ion.com/cf_lists/unsubscribe.cfm?user=30316.21480.4 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289131 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
