Mac Forum / Applications / Other MS Products / September 2004

Will,

Thanks for the additional info. For VPC6, it sounds like you are maxed-out
for performance. One thing I didn't understand dealt with the SQL Server.
Are you running a SQL client to a central SQL Server DB with the ACT data or
are you actually running a local db/server on your PB to house the ACT data?  
If it is the prior, you may have network traffic delays being experienced vs
the prior ACT with no DB access (all local files). If you are actually running
SQL Server DB software on your PB, you will also take a big hit due to the
added work of churning the server app and relational db files each time you
perform a function in ACT.

From the MSDE 2000 Home Page,

[The Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is a data
engine built and based on core SQL Server technology. With support for
single- and dual-processor desktop computers, MSDE 2000 is a reliable
storage engine and query processor for desktop extensions of enterprise
applications. The common technology base shared between SQL Server and
MSDE 2000 enables developers to build applications that can scale
seamlessly from portable computers to multiprocessor clusters.

Designed to run in the background, supporting transactional desktop
applications, MSDE 2000 does not have its own user interface (UI) or tools.
Users interact with MSDE 2000 through the application in which it is
embedded. MSDE 2000 is packaged in a self-extracting archive for ease of
distribution and embedding.]

I read this as adding additional processing loads that the previous ACT
didn't impose on your PB. Your only recourse may be some relief in VPC7, as
you are pursuing.

Regards,

Wyatt