A
Atlas
Scenario:
- Server: Win2k SBS + MS SQL Server 2000 + latest SP on a P2-300 +
600MB-RAM;
- Test PC: WinXP + AC2003 ona a P3-1000 + 390MB-RAM;
- LAN: FastEthernet on a FastEthernet Switching HUB;
- Adp project;
Only with few records in the DB while developing, I'm noticing a
not-very-fast execution of my app, specially when opening forms with rows
obtained from multiple tables and complex subforms. Also when changing
programmatically the recordsource property, executing a query it takes 1/2
seconds.
Is that normal or I should start worring?
Is it just a "startup" lag and will it be the same with thousands records,
or it will be worst?
SQL related code is executing locally or on the server? If not the latter,
may I force execuitng SQl code on the server ?
Bye
- Server: Win2k SBS + MS SQL Server 2000 + latest SP on a P2-300 +
600MB-RAM;
- Test PC: WinXP + AC2003 ona a P3-1000 + 390MB-RAM;
- LAN: FastEthernet on a FastEthernet Switching HUB;
- Adp project;
Only with few records in the DB while developing, I'm noticing a
not-very-fast execution of my app, specially when opening forms with rows
obtained from multiple tables and complex subforms. Also when changing
programmatically the recordsource property, executing a query it takes 1/2
seconds.
Is that normal or I should start worring?
Is it just a "startup" lag and will it be the same with thousands records,
or it will be worst?
SQL related code is executing locally or on the server? If not the latter,
may I force execuitng SQl code on the server ?
Bye