Página 1 de 1

TDBBrowse

Publicado: Jue Jul 29, 2010 4:13 pm
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?

TDBBrowse

Publicado: Sab Jul 31, 2010 1:34 pm
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?