Performance tips - Rookie

[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?

 

[Lyle Fairfield]

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?

1. Don't believe everything you hear.
2. Don't believe everything you read.
3. Wizards have to anticipate everything. Hence, the objects they create
may be slow.
4. The creators of some Wizards are not wizards.
5. Learn your trade.
6. Ask specific questions.

 

[Atlas]

6. Ask specific questions.
How interesting.............

How about any helpful hint, like a performance primer?

 

[Guest]

uh

http://www.sqlserverperformance.com

and of course-- SQL Server Books Online

read both of them daily-- just peruse them until you get to know this stuff
better.

if you want help on MSNIM, email me or add me