Compact question

[reemi1979]

Hi,





I have 2 computers here;
PC #1 :
Windows 2012 server 64bits, with Microsoft Office 2010 32bits.

PC #2 :
Windows 2010 64bits, with Microsoft Office 2010 32bits.

I have a Frontend 100% VBA process that I run, with a timer in milisecond. (it's a data copy from table A, B, C, D, to Table E)

All tables are in the backend.accdb database.

When I compact my backend .accdb with PC #1, the process take 77sec to complete.

When I compact my backend .accdb with PC #2, the process take 7sec to compete.

I always run the frontend process in the same folder, on PC #1
The backend database is always in the same folder, on PC #1

So, I only use another PC for compacting and it increase performance.

If I compact with PC#1, its slow, if I compact it with PC #2 then it will be fast, and if I use PC #1 again it will be slow again...

why...

[ArviLaanemets]

I always run the frontend process in the same folder, on PC #1
The backend database is always in the same folder, on PC #1

So for what you have PC #2 there?

In case you have your back-end on server, when you compact front-end, you compact elements in this particular front-end file (forms, reports, links to back-end tables, VBA code, etc.). When you compact back-end, you compact elements in back-end file (mainly tables there).

[reemi1979]

So for what you have PC #2 there?

In case you have your back-end on server, when you compact front-end, you compact elements in this particular front-end file (forms, reports, links to back-end tables, VBA code, etc.). When you compact back-end, you compact elements in back-end file (mainly tables there).

check my image.

Fyi, my tests are always done on the server with "Automated Process" connected to server DB.

I only compact with my PC#2 then I copy the DB to the server = faster result.
If I ask the server to compact = slow result (almost 10 times)

PC #2 is a VERY VERY high end PC.

[ArviLaanemets]

An idea for possible cause.

PC#2 is a high-end computer where you compact your copy of database back-end situated there. And when you compact it, there is nobody connected to it.

PC#1 is a server which allows multiple remote connections (A terminal server?). And there is a sheduled process activated daily, which compacts database back-end in some folder on same server.
How is the backup sheduled? Can some remote users be connected at same time, or do you kick them out before compacting?

Another one: Are the folders in PC#1 for your back- and front-ends local folders, or network resources?