April 22, 2002 9:44 AM
To: CF-Talk
Subject: Re: Access /SQL Server
Memory issues? MS SQL 2000 will use a lot more memory. When working with
small tables and datasets you may be staying within the bounds of physical
memory on the machine and never notice a difference. If you force the
system t
swapping to disk.
Jim
- Original Message -
From: "Jerry Staple" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 22, 2002 9:33 AM
Subject: RE: Access /SQL Server
> Andy,
> It is only selecting data and it is running on th
-
From: Jerry Staple [mailto:[EMAIL PROTECTED]]
Sent: 22 April 2002 16:33
To: CF-Talk
Subject: RE: Access /SQL Server
Andy,
It is only selecting data and it is running on the same server
as the access versions?
We would appreciate any advice.
Jerry
-Original Message-
From: Andy E
Andy,
It is only selecting data and it is running on the same server
as the access versions?
We would appreciate any advice.
Jerry
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 22 April 2002 16:13
To: CF-Talk
Subject: RE: Access /SQL Server
Sounds
Sounds like the majority processing on this page is CF. Check the debugging
output and see how long the SQL queries take. If your SQL queries are
taking a noticable abmount of time then I'd suggest ensuring that your
indexes are correct and that your Transact SQL is effecient. Without seeing
th
5 matches
Mail list logo