[AccessD] Create New DB + link table check (Was: Major Performance issue)

Gustav Brock gustav at cactus.dk
Fri Jan 23 06:03:24 CST 2004


Hi Sad

JC has a demo for this purpose:

  http://www.colbyconsulting.com/C2DbDemoBEBuild.htm

But I wonder if this is the only method. If your source data are the
same for all queries you can open a snapshot (which copies the data
once), leave it open; then query this - which should take a couple of
seconds. 

If you are able to write protect the frontend (main) then, of course,
no temporary data will be written into it and no bloat will occur.

/gustav


> 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.



More information about the AccessD mailing list