B
Bill
Make sure your network connection between your SQL server
and your application server has a high bandwidth. Second,
what is the configuration of the servers for SQL and your
application server?
Bill
through ViewDrop (8 to 15 minutes) to move data to
Project Web Access. During this period of time, any
queries to the PWA tables don't process. We have an
external time keeping/billing system that is impacted as
well as our custom reports. We are using Access 2000 with
an Access Data Project for ad-hoc queries and reports. We
have two servers, one for the SQL server and the other
being shared for Project Server, Sharepoint and our
timekeeping/billing application.
and your application server has a high bandwidth. Second,
what is the configuration of the servers for SQL and your
application server?
Bill
including summaries) that take a very long time to process
through ViewDrop (8 to 15 minutes) to move data to
Project Web Access. During this period of time, any
queries to the PWA tables don't process. We have an
external time keeping/billing system that is impacted as
well as our custom reports. We are using Access 2000 with
an Access Data Project for ad-hoc queries and reports. We
have two servers, one for the SQL server and the other
being shared for Project Server, Sharepoint and our
timekeeping/billing application.