Board index » delphi » HELP: DBE & NT Server

HELP: DBE & NT Server

En primer lugar os quiero perdir perdn por redactar este mensaje en
Castellano, pero el texto es lo suficiente complejo para mi nivel de
ingls y deseo que sea entendido (aunque solo sea por los que sabeis
leer castellano ;-) )

Si alguien desea contestarme, hacerlo en este rea de las News o a la
cuenta de correo "nemes...@redestb.es". Por supuesto podeis contestar en
ingls.

He realizado un programa, mas o menos grande con Delphi 3.
La base de datos que tiene usa el driver e Paradox.
La aplicacin se encuentra en una mquina con NT server r4.0,
compartiendo el directorio al resto de la red.
Desde el resto de los ordenadores de la red (Window NT workstation)
ejecuto la aplicacin creando una unidad de red local.
El DBE instalado en todas las mquina es el ltimo r4.51.
Las Windows NT estn con los services pack 2 (para castellano no hay
ms).

El problema:

La aplicacin ejecutada desde cualquiera de los ordenadores de la red,
excepto el servidor (donde realmente reside la aplicacin), va
extraordinariamente lenta al acceder a los datos; tarda ms de 40
segundos en arrancar, el acceso a cualquiera de la tablas es muy lento y
las consultas SQL se eternizan.

Para confundir ms las cosas, hay van otros datos:

En la red hay un equipo con Windows 95, y desde este la aplicacin se
ejecuta a la velocidad correcta, solo un poco ms lenta que en el
servidor (realmente, apenas ms lenta).
Si instalo la aplicacin en una de las mquina con Workstation y la
comparto al resto de la red (anulando la del servidor) la velocidad de
ejecucin es la correcta.

Bueno, espero que a alguien se le ocurra algo, puesto que ya he probado
todo y no encuentro ninguna razn ni camino por la que seguir probando.

Saludos desde Espa?a: FRAN

 

Re:HELP: DBE & NT Server


I have no idea what is causing this, but at least I can translate it for
others.

Juan Francisco Puentes Calvo wrote in message
<34B5F630.C3AB1...@redestb.es>...

First of all, I apologize for composing this message in Spanish, but the
text is very complex for my knowledge of English, and I wish for it to be
clearly understood (even if only by those of you who can read Spanish).

If anyone wishes to answer me, please do so in this newsgroup or by email to
nemes...@redestb.es. Of course, you may reply in English.

I have developed an application, relatively large, with Delphi 3. The
database uses the Paradox driver. The application resides on an NT 4.0
server, on a folder shared to the rest of the network. From the other
workstations on the network (Win NT Workstation) y execute the application,
creating a local network unit. The BDE installed on all machines is the
latest one, 4.51. The Windows NT workstations are up to Service Pack 2
(there are no more service packs for the Spanish language version).

The problem:

The application, when executed from any of the workstations on the network,
except the server (where the application actually resides) y extraordinarily
slow to access the data, it takes more than 40 seconds to launch, the access
to any of the tables is very slow and the SQL queries take forever.

To further confuse the issue, here is more information.

On the network there is a Windows 95 box, and from this one the application
executes at a normal speed, only slightly slower than the server (and barely
noticeably). If I install the application in one of the NT Workstation
machines and I share it to the rest of the network (removing the one on the
server), the execution speed is normal.

Well, I hope someone can think of something, as i have I tried everything I
can think of and I cannot find a reason for this, nor any further means of
troubleshooting the problem.

Regards from Spain, FRAN

Re:HELP: DBE & NT Server


I have given up on getting an answer on the NT/BDE slooow performance
problem.  I rewrote my app using VB5.  Even using the (interpreted) Learning
Edition, it runs much faster than the Delphi 3/BDE version.  VB isn't nearly
as powerful or versatile as Delphi but for now, it will have to do.

Quote

Other Threads