In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.

Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.

TDBBrowse

Xailer professional forum in English
Responder
Maarten Roos
Mensajes: 126
Registrado: Lun Mar 29, 2010 10:24 am

TDBBrowse

Mensaje por Maarten Roos »

I already had noticed on my own computer, but now connected to a database server it really shows up.
I have a TDBBrowse with a dataset to a database with 84000 records. I created a setrelation to other databases, because I want to show the full names in the browser instead of the ID's.
When I use the filterbar to search on for example relation name, it is slower as when I search directly on relation ID. When filtering is finished and browser has it's data which I wanted and I start to browse/scroll from record to record it hangs for a couple seconds. When I look to processor of server it goes up every time I browse/scroll? Why is that? I am doing something wrong?
Avatar de Usuario
ignacio
Site Admin
Mensajes: 9447
Registrado: Lun Abr 06, 2015 8:00 pm
Ubicación: Madrid, Spain
Contactar:

TDBBrowse

Mensaje por ignacio »

Maarten,
The filter bar uses ADS own filter mechanism and indeed can be slow when
filtering related databases.
Regards,
"Maarten Roos" <m[dot]roos[at]ecem[dot]com> escribió en el mensaje de
noticias:4c518c98$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> I already had noticed on my own computer, but now connected
> to a database server it really shows up.
>
> I have a TDBBrowse with a dataset to a database with 84000
> records. I created a setrelation to other databases, because
> I want to show the full names in the browser instead of the
> ID's.
>
> When I use the filterbar to search on for example relation
> name, it is slower as when I search directly on relation ID.
> When filtering is finished and browser has it's data which I
> wanted and I start to browse/scroll from record to record it
> hangs for a couple seconds. When I look to processor of
> server it goes up every time I browse/scroll? Why is that? I
> am doing something wrong?
Ignacio Ortiz de Zúñiga
[OZ Software]
https://www.ozs.es
--
[Equipo de Xailer / Xailer team]
https://www.xailer.com
Responder