Willo,
Cita:
Empezado por Willo
...tengo trabajando con Advantage desde hace varios años; conozco la BD. Me inclino mas a pensar en un problema de SO...
|
Pregunto:
1- ¿Que versión de Delphi usan las aplicaciones?
2- ¿Que motor de datos usan las aplicaciones para el acceso a la BD?
3- ¿Cual es la versión de Advantage Database actualmente en uso?
Revisa esta información:
Cita:
Empezado por Sybase
Advantage Database Server Hardware Requirements
Performance Tips
Before upgrading hardware to resolve performance issues, see the Performance Factors in the Advantage help file. Additionally, the following tips have resolved many high CPU utilization issues:
1- Use the query logging utility (Advantage v8.0 or higher) or analyze the application code to verify that all SQL statements and filters are optimized using the SQL Debugger (Advantage Data Architect v9.0 or higher). Statements or filters are optimized if they are able to use existing indexes.
If statements or filters are not optimized, additional processing is required by the server, which can be very CPU intensive. Building the appropriate indexes resolves a majority of CPU utilization issues. Typically, end-users should contact their software vendor for index specifications.
2- If using DBF files, pack the tables. This will remove deleted records and re-build existing indexes.
3- Upgrade to Advantage Database Server. Version 11 is the fastest performing version of Advantage ever. If CPU utilization is low, the network is typically the bottleneck for most application processes. Application developers should implement as much server-side processing as possible, including SQL processing, stored procedures and triggers. As a trouble-shooting step, the application can be run on the server to determine the network performance lag.
If performance improvement is dramatic, administrators can start to isolate the network to identify faulty or slow network hardware.
|
Espero sea útil
Nelson.