A
Atlas
I'm currently devoloping a small app with about 15 forms and 15 tables with
ac2003 + SQL Server 2000 on W2k.
I've read that that's not the best speed option especially using access as
the frontend.
But I'm here, and working allready. And while working I'm thinking about
tips that can improve speed and performance, apart from hardware config, in
the code.
Basically I'm letting the form wizard doing everything, sticking small parts
of code somewhere, just to enforce checking; using lookuptables with sql
statements.
Main table will hold about 2000 recs per year, not very long recsize.
Related table to main about 6000. (example Orders/Details).
A few clients.
Timestamp everywhere. I've read this improves record locking check.
In the development environment the client runs on PIII-1000 with 400MB RAM,
Fast Ethernet and a W2K server running on a P2-400 + 512 MB RAM.
The production environment will be both clients and server on P4 based
machines.
Will be running in /runtime environment
In the development environment when launching the main form, it takes a few
secs to load subform; afterwards it perform smoothly.
Also when inserting new recs minor glitches are reported.
Any tip?
ac2003 + SQL Server 2000 on W2k.
I've read that that's not the best speed option especially using access as
the frontend.
But I'm here, and working allready. And while working I'm thinking about
tips that can improve speed and performance, apart from hardware config, in
the code.
Basically I'm letting the form wizard doing everything, sticking small parts
of code somewhere, just to enforce checking; using lookuptables with sql
statements.
Main table will hold about 2000 recs per year, not very long recsize.
Related table to main about 6000. (example Orders/Details).
A few clients.
Timestamp everywhere. I've read this improves record locking check.
In the development environment the client runs on PIII-1000 with 400MB RAM,
Fast Ethernet and a W2K server running on a P2-400 + 512 MB RAM.
The production environment will be both clients and server on P4 based
machines.
Will be running in /runtime environment
In the development environment when launching the main form, it takes a few
secs to load subform; afterwards it perform smoothly.
Also when inserting new recs minor glitches are reported.
Any tip?