Jim Lawrence (AccessD)
accessd at shaw.ca
Fri Jan 23 19:28:30 CST 2004
Hi Sad: Check the article at the DBA, http://www.databaseadvisors.com/newletters/newsletter112003/0311UnboundRepor ts.htm (watch for wrap clip) It demonstrates exactly what you have discovered, when working with large data sets. It is sometimes more efficient to download the data and post process it. Some of the code in this article may help you. HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Sad Der Sent: Friday, January 23, 2004 1:44 AM To: Acces User Group Subject: [AccessD] Create New DB + link table check (Was: Major Performance issue) Hi group, I've got a solution to my performance problem. Before the users start their analyses I copy the data to the local database! Copying the data takes about 45-55 seconds, calculating the data LESS THEN 2 seconds!! :-) I don't want this copied data in the original client so I want to create a new mdb. I don't have my A2KDH Enterprise Edition with me I'm asking you guys. Does anybody have a (set of) function(s) to create a DB with tables and link to it? I've searched wolfwares.com but I couldn't find any of it and this subject has to be discussed here at some point....or not? The idea is: User needs to use the Analyses tool Create new TEMP DB (duration: ?) Create tables (duration: ?) Check links (duration: ?) Copy data from BE (duration: 45-55 seconds) When user stops the MAIN application (= Analyses tool is part of the MAIN application) delete the TEMP DB. TIA Sad __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com