Diese Seite mit anderen teilen ...

Informationen zum Thema:
WinDev Forum
Beiträge im Thema:
Erster Beitrag:
vor 9 Jahren, 1 Monat
Letzter Beitrag:
vor 9 Jahren, 1 Monat
Beteiligte Autoren:
Louis Verbraak, ICI, issah

[WD12] HReadSeekFirst faster as TableSeek?

Startbeitrag von Louis Verbraak am 15.06.2009 09:05

Hello to you all,

I found out with ProfilerStart() and ProfilerEnd() that it is faster to find a record with HReadSeekFirst than to find the same value in a table with TableSeek. The difference is significant (1s 856 ms for TableSeek and 2 ms. for HReadSeekFirst). I didn't expect this. The table (and the file) consists of about 4500 records and I use the table with indirection.

Did anyone encountered this as well and is there a advice when to use TableSeek of HReadSeekFirst?


Maybe its the indirection???



von issah - am 15.06.2009 10:04
Hello Issah,

There is a difference in using indirection from another program or from a report. From another program executes quit fast (almose as fast as without indirection), but from the report it's very time-consuming.

von Louis Verbraak - am 15.06.2009 14:55
Yes Louis.
I also see in my applications. TableSeek and also Seek integrated into column header is slower than HReadSeekXX and TableDisplay() from EDT_Box.
Also 1s is slow with only 4800 records, when I compare with my old application using DBFs and I was thinking that my old application is slow with search sometime. But your result is, hm.

Regards !

von ICI - am 15.06.2009 16:57
Hello Ici,

Thanks for your time. I'll use HReadSeekFirst.

von Louis Verbraak - am 15.06.2009 17:04
HReadSeekFirst is not absolute solution.
Column header integrated seek (based on your table keys) is much comfortable solution than you always make "edt_box" controls. You heft to decide where you will use your seek solution, but to make edt_boxes for all your keys into tables is not always good.
When you have 3,5 or maybe than keys and user wnat to seek on all of them.
Think about it. I prefer to use integrated solution except some situations.

Once again. Don't accept my reply like final solution and again think. :cheers:

von ICI - am 15.06.2009 19:58
Hello Ici,

Once again. Don't accept my reply like final solution and again think.

I will. Thanks again.

von Louis Verbraak - am 15.06.2009 21:07
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.