All, I have a database that is growing in size (8MB for the Backend) via network. It is painful somedays when traffic is heavy. What I have done, with the help of some folks here, to write a DAO to keep the Database open. Well, I think I see a little improvement but wonder if there are other thoughts? Ty in advance.
p.s.: I did search up on the web about possible solutions but some involves me re-writing the database or very extensive changes which I don't have the time for that. I was wondering if there are some other means. Ty again.