When I split my DB into a FE and BE I expected a decrease in performance when going into forms, reports, and queries etc. What I didn't expect it for the forms to take so long going into design mode. I am having this kind of problem through my development FE environment. It is also a lot slower with just Open Mode as well.
I have read through threads posted here but nothing seemed to help. The network shouldn't be the problem but could the server the BE is sitting on be the problem? Meaning the amount of RAM and how much processor speed the server has?
The DB is A2K front and back end. The production FE size is 11.5 MB, development FE is 22 MB and the BE is 6.5 MB. I have, per suggestion of an article I read, imported everything to a new DB, decompiled, recompiled, and compacted the DB. It did reduce the size but didn't help with the speed.
To answer upfront, "Yes" there could be some fine-tuning and maybe rewriting of some SQL statements and VBA code. The DB application performance the way it is now is unacceptable and I do not have the time to do the rewriting because that is unacceptable to the project manager and executive management.
Are there any other tricks to speeding the application up? Again opening a form in design shouldn't take anytime at all because that is local and going directly to design mode shouldn't have to access the BE so this one has stumped me most.
Thanks for any suggestions.
Remember the Past, Plan for the Future, yet Live in the Now for tomorrow may never come.
-etrain
I have read through threads posted here but nothing seemed to help. The network shouldn't be the problem but could the server the BE is sitting on be the problem? Meaning the amount of RAM and how much processor speed the server has?
The DB is A2K front and back end. The production FE size is 11.5 MB, development FE is 22 MB and the BE is 6.5 MB. I have, per suggestion of an article I read, imported everything to a new DB, decompiled, recompiled, and compacted the DB. It did reduce the size but didn't help with the speed.
To answer upfront, "Yes" there could be some fine-tuning and maybe rewriting of some SQL statements and VBA code. The DB application performance the way it is now is unacceptable and I do not have the time to do the rewriting because that is unacceptable to the project manager and executive management.
Are there any other tricks to speeding the application up? Again opening a form in design shouldn't take anytime at all because that is local and going directly to design mode shouldn't have to access the BE so this one has stumped me most.
Thanks for any suggestions.
Remember the Past, Plan for the Future, yet Live in the Now for tomorrow may never come.
-etrain