oBrw:SetDbf() Slowness

[Aguiar Costa]

Hello!
I'm having problems browsing some tables. Using SetDbf() method from the
browse class some tables take a lot of time to be showned. Sometimes it
takes more than 1 minute. Some features we are using:
- Table has more than 300 000 records
- Table has 60 fields (we just show 2)
- Server is Novell with Ads
- I'm using AdsDataSource (Remote)
- Browse is TDbfBrowse
We use browses a lot to make incremental searches. Sometimes in our office
with Microsoft Sever2003 (and ADS) it's slow just the first time the
programme is lunched, then it works just fine opening the same table
instananiously.
What's the problem here ? Is it ADS ? Is it the Server ? Or it's slow
because of of the number of records and fields?
The same prgramme in FWH has no speed problem. We are presenting Xailer to
our customers as an improvement of our FWH programmes. Right now we can not
go back....We really need your help to solve this!!!
TIA.
Regards
Aguiar !!!

[ignacio]

Aguiar,
Maybe the problem is due the use of OrdKey??? functions which are really
slow. Try to put the following on any Browse:
WITH OBJECT oBrw
:OnKeyCount := {|oSender| ( oSender:cAlias )->( RecCount() ) }
:OnKeyNo := {|oSender, nPos | iif( nPos != NIL, ( oSender:cAlias )->(
DbGoto( nPos) ), ( oSender:cAlias )->( Recno() ) ) }
END WITH
With this code when an index is active the vertical scrollbar will not work
accurately but it should be a lot faster. Could you test it please?
BTW I can do some tests here with ADS+WIN2003Server if you send me the
table (compressed please) or give me an FTP or HTTP link to download it.
Regards,
"Aguiar Costa" <aguiar.costa@sisbit.pt> escribió en el mensaje
news:447f2175$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
> Hello!
>
> I'm having problems browsing some tables. Using SetDbf() method from the
> browse class some tables take a lot of time to be showned. Sometimes it
> takes more than 1 minute. Some features we are using:
> - Table has more than 300 000 records
> - Table has 60 fields (we just show 2)
> - Server is Novell with Ads
> - I'm using AdsDataSource (Remote)
> - Browse is TDbfBrowse
> We use browses a lot to make incremental searches. Sometimes in our office
> with Microsoft Sever2003 (and ADS) it's slow just the first time the
> programme is lunched, then it works just fine opening the same table
> instananiously.
> What's the problem here ? Is it ADS ? Is it the Server ? Or it's slow
> because of of the number of records and fields?
> The same prgramme in FWH has no speed problem. We are presenting Xailer to
> our customers as an improvement of our FWH programmes. Right now we can
> not go back....We really need your help to solve this!!!
> TIA.
> Regards
> Aguiar !!!
>
>
>

[Aguiar Costa]

Ignacio,
I think you found the solution
Here it is working just fine with your code. We will have to test it on our
client that uses Novell server. I'll inform you the results.
Thank you very much for the great support.
Best Regards
Aguiar !!!
"Ignacio Ortiz de Zúñiga" <NoName@xailer.com> escreveu na mensagem
news:447f2d1d$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
> Aguiar,
>
> Maybe the problem is due the use of OrdKey??? functions which are really
> slow. Try to put the following on any Browse:
>
> WITH OBJECT oBrw
> :OnKeyCount := {|oSender| ( oSender:cAlias )->( RecCount() ) }
> :OnKeyNo := {|oSender, nPos | iif( nPos != NIL, ( oSender:cAlias )->(
> DbGoto( nPos) ), ( oSender:cAlias )->( Recno() ) ) }
> END WITH
>
> With this code when an index is active the vertical scrollbar will not
> work accurately but it should be a lot faster. Could you test it please?
>
> BTW I can do some tests here with ADS+WIN2003Server if you send me the
> table (compressed please) or give me an FTP or HTTP link to download it.
>
> Regards,
>
> "Aguiar Costa" <aguiar.costa@sisbit.pt> escribió en el mensaje
> news:447f2175$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
>> Hello!
>>
>> I'm having problems browsing some tables. Using SetDbf() method from the
>> browse class some tables take a lot of time to be showned. Sometimes it
>> takes more than 1 minute. Some features we are using:
>> - Table has more than 300 000 records
>> - Table has 60 fields (we just show 2)
>> - Server is Novell with Ads
>> - I'm using AdsDataSource (Remote)
>> - Browse is TDbfBrowse
>> We use browses a lot to make incremental searches. Sometimes in our
>> office with Microsoft Sever2003 (and ADS) it's slow just the first time
>> the programme is lunched, then it works just fine opening the same table
>> instananiously.
>> What's the problem here ? Is it ADS ? Is it the Server ? Or it's slow
>> because of of the number of records and fields?
>> The same prgramme in FWH has no speed problem. We are presenting Xailer
>> to our customers as an improvement of our FWH programmes. Right now we
>> can not go back....We really need your help to solve this!!!
>> TIA.
>> Regards
>> Aguiar !!!
>>
>>
>>
>
>
>