mdb size 2

[DBrack]

Hello,

Is there a maximum size a mdb should be limited for better performance. Is it 2gb? We currently have an mdb of 17gb size. Performance is not great. Ay thoughts?

 

[JoeAtWork]

2 GB is the limit. Have you ever compacted it?

 

[Golom]

Yes ... 2GB is the max.

I assume that you have been compressing this database. If you haven't then do so ASAP. The usual rule of thumb is that performance degredation becomes apparent at around 90% of the max size.

PS: I assume that your specified 17gb was meant to be 1[COLOR=red yellow].[/color]7gb.

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[DBrack]

Thank you.. Sorry, you are right, its not even 1.7gb. Its only 17mb.

One more question: Is there a procedure to maximize the number of concurrent users to access? Thanks in advance.

 

[Golom]

Oh ... that's different.

17Mb isn't particularly large for an Access database. Do a compact and repair on it. You may also want to review your tables and be sure that fields being used in JOIN conditions or WHERE clauses are indexed.

I infer that everyone is opening the same mdb file. You should probably split it into a Front-end / Back-end system and give everyone their own front-end. That should make a significant performance difference.

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]