Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Slugghish TADSQuery with 'FindNearest' over the internet

2 posts in Internet Server Last posting was on 2007-04-10 10:08:32.0Z
Jim Gabriel Posted on 2007-04-07 14:16:56.0Z
From: "Jim Gabriel" <nospam@gmail.com>
Newsgroups: Advantage.Internet_Server
Subject: Slugghish TADSQuery with 'FindNearest' over the internet
Date: Sat, 7 Apr 2007 07:16:56 -0700
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 71.104.132.62
Message-ID: <4617a6e7@solutions.advantagedatabase.com>
X-Trace: 7 Apr 2007 08:12:55 -0700, 71.104.132.62
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!71.104.132.62
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:722
Article PK: 1120984

I have sluggish perfomance doing a 'FindNearest' on a TADSQuery over the
internet.

I have a Query displayed within a grid. I have a 'search' field that does
an autoincrement search against the query in the 'OnChanged' event of the
Tedit field. I'm using a 'FindNearest' on what the user has typed.

Apparently, this is going back to the server to do the 'FindNearest' since I
can see 'Operations Since Started' change on the Advantage config Utility
form. Is there a way to implement this incremental search without going
back to the server? The problem with sluggish perfomance is if the user
types too fast, keys strokes occassionally are getting transposed in the
"search for" field. e.g. If the user types '123' really fast, it will
appear in the edit field as '132'.

I NEVER see this running on a local machine, but I do see it running the
same app against the same data over the internet.

Jim


Joachim Duerr (ADS) Posted on 2007-04-10 10:08:32.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Slugghish TADSQuery with 'FindNearest' over the internet
Newsgroups: Advantage.Internet_Server
References: <4617a6e7@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.18.1.2
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 10.56.66.118
Message-ID: <461b5410@solutions.advantagedatabase.com>
Date: 10 Apr 2007 03:08:32 -0700
X-Trace: 10 Apr 2007 03:08:32 -0700, 10.56.66.118
Lines: 31
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.56.66.118
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:723
Article PK: 1120985


Jim Gabriel wrote in <4617a6e7@solutions.advantagedatabase.com>:

> I have sluggish perfomance doing a 'FindNearest' on a TADSQuery over
> the internet.
>
> I have a Query displayed within a grid. I have a 'search' field that
> does an autoincrement search against the query in the 'OnChanged'
> event of the Tedit field. I'm using a 'FindNearest' on what the
> user has typed.
>
> Apparently, this is going back to the server to do the 'FindNearest'
> since I can see 'Operations Since Started' change on the Advantage
> config Utility form. Is there a way to implement this incremental
> search without going back to the server? The problem with sluggish
> perfomance is if the user types too fast, keys strokes occassionally
> are getting transposed in the "search for" field. e.g. If the user
> types '123' really fast, it will appear in the edit field as '132'.
>
> I NEVER see this running on a local machine, but I do see it running
> the same app against the same data over the internet.

I usually put a timer on the form. Every key stroke enables the timer
and sets the interval to 100 msec. In the time event I disable the
timer and do the findnearest. So if the user types to fast, the app
does nothing until the user stops typing for at least 100 msecs.

--
Joachim Duerr
System Consultant (Advantage Database Server)
Sybase iAnywhere
advantagesupport[AT]ianywhere.com