developingprogrammer
asked on
complete cache of DB
hey guys i've got a big report i need to run and the database is on the network. that means that the calls always takes very long and the multiple trips are a penalty. how do i create a local cache of the relevant tables when i'm running this mammoth report at the end of every week?
i'm thinking 3 ways
1) Access's synchronisation
2) DIY synchronisation
3) just copy the whole database to local machine, change the links of the table to the local database, run the report, link the tables back to the network database, then delete the local database
what do yall think guys? looking forward to your guidance and sharing guys = )
i'm thinking 3 ways
1) Access's synchronisation
2) DIY synchronisation
3) just copy the whole database to local machine, change the links of the table to the local database, run the report, link the tables back to the network database, then delete the local database
what do yall think guys? looking forward to your guidance and sharing guys = )
I vote for # 3 also.
ASKER
Cool, thanks guys, but if I didn't suggest number 3, how would y'all have done it? I think your methods should definitely be better than mine with all the experience y'all have! = )
Yes I would have suggested it, because that is exactly what I do (in an automated fashion) on one of our reporting KPI databases.
:-)
:-)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hrmm nice guys. I super like the ideas!! = ))
Hrmm may be a silly question, but if a db has one table with 100,000 records, is it faster in terms of "localising" it by
1) copying the whole database
2) reading the linked table and copying to temp table?
One is wholesale one is pinpoint (so to speak if there were more tables we want to ignore)
Hrmm may be a silly question, but if a db has one table with 100,000 records, is it faster in terms of "localising" it by
1) copying the whole database
2) reading the linked table and copying to temp table?
One is wholesale one is pinpoint (so to speak if there were more tables we want to ignore)
I generally just copy exactly what I need into the temp table, not scientific, just the way I do things.
ASKER
Yup I agree. Looks more elegant that way as well. What do you think MX? And also from a performance angle MX? = ) thanks guys!!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Joe,
That's because you have a blazingly fast network!
;-)
That's because you have a blazingly fast network!
;-)
Yep ... But it's **not** the only one in the World, contrary to popular belief :-)
I'm just jealous.
ASKER
Superb!!! Thanks guys!! = ))
the best way is option 3.