Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
4
Erster Beitrag:
vor 8 Jahren
Letzter Beitrag:
vor 8 Jahren
Beteiligte Autoren:
Hans60, issah, Fabrice Harari.pcs.crosspost

Filter - PPC Performance

Startbeitrag von Hans60 am 25.08.2009 09:27

I have several databses with several thousand records related to each other.

After I have linked the records using this local procedure to filter the performance has droped to a level which is not usable anymore.
The selection is initiated by Row election

How could the performance be enhanced?

At the moment row select will triger the filter, how can it be done that selecting a tab will do that?

PROCEDURE DisplayRunway()

///////////////////////////////////////////////////////
// Contact details
FileToScreen(WIN_Table_AP, AP)

///////////////////////////////////////////////////////
// Products associated with this supplier
HFilter(RWY,AP_IDENT,AP.gps_code)
// Redisplays the table of products
TableDisplay(TABLE_RWY, taInit)

Thanks for any input.
Hans

Antworten:

Hello Hans...

What are your table settings? And what is 'not usable level of
performance'?

Best regards

--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

More information on http://www.fabriceharari.com


Hans60 wrote:
> I have several databses with several thousand records related to each other.
> After I have linked the records using this local procedure to filter the performance has droped to a level which is not usable anymore.
> The selection is initiated by Row election
> How could the performance be enhanced?
> At the moment row select will triger the filter, how can it be done that selecting a tab will do that?
> PROCEDURE DisplayRunway()
> ///////////////////////////////////////////////////////
> // Contact details
> FileToScreen(WIN_Table_AP, AP)
> ///////////////////////////////////////////////////////
> // Products associated with this supplier
> HFilter(RWY,AP_IDENT,AP.gps_code)
> // Redisplays the table of products
> TableDisplay(TABLE_RWY, taInit)
> Thanks for any input.
> Hans
>
Message forwarded from pcsoft.us.windev

von Fabrice Harari.pcs.crosspost - am 25.08.2009 11:19
Make sure you have the right indexes in place. Have you considered queries??

regards

issah

von issah - am 26.08.2009 12:27
Thanks for input Fabrice and Issah... I had no time lately. I have checked on your suggested items in question and found the problem.
Many thanks.
Performance is ok again ,as good as with MS pocket SQL
Hans

von Hans60 - am 31.08.2009 20:39
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.