Hi,
I have a problem with cxgrid (Devexpress) and a TEDBQuery as source. I use
to change "order by" (with close and open) SQL on the fly on colunm header
click and it works well. Work well and performance are good when scroll and
fetch records. But incremental search in grid don't work. PC hang up. If  i
use an external WWincremetalsearch components, it work. But searches in
cxgrid don't work with TEDBQuery.
Any workaround? Any suggestion?
Thanks in advance!

Stefano Monterisi


Documento senza titolo Stefano Monterisi - monterisi@sesamoweb.it Sesamo
Software S.p.A. Via Adamello, 2 71042 Cerignola (Fg) Tel.: +39 0885 416969 -
421501 - 421502 - 416392 Fax: +39 0885 444925 Filiale Via Premuda, 3 00195
Roma Tel.: +39 06 3220238 Fax: +39 06 32646539 www.sesamoweb.it D.L. 30
giugno 2003 n. 196 e D.L. 24 dicembre 2003 n. 354 (tutela dei dati
personali) ------------------------------------------------------------------------------------------------------
INFORMAZIONI STRETTAMENTE CONFIDENZIALI Questo messaggio di posta
elettronica contiene informazioni di carattere confidenziale rivolte
esclusivamente al destinatario sopra indicato. E' vietato l'uso, la
diffusione, distribuzione o riproduzione da parte di ogni altra persona. Nel
caso aveste ricevuto questo messaggio di posta elettronica per errore, siete
pregati di segnalarlo immediatamente al mittente e distruggere quanto
ricevuto (compresi i file allegati) senza farne copia. Qualsivoglia utilizzo
non autorizzato del contenuto di questo messaggio costituisce violazione
dell'obbligo di non prendere cognizione della corrispondenza tra altri
soggetti, salvo più grave illecito, ed espone il responsabile alle relative
conseguenze. ------------------------------------------------------------------------------------------------------
CONFIDENTIALLY NOTICE This e-mail transmission may contain legally
privileged and/or confidential information. Please do not read it if you are
not the intended recipient(S). Any use, distribution, reproduction or
disclosure by any other person is strictly prohibited. If you have received
this e-mail in error, please notify the sender and destroy the original
transmission and its attachments without reading or saving it in any manner.
Questo messaggio prima dell'invio è stato controllato con Kaspersky
Antivirus 6.0

Stefano,

<< I have a problem with cxgrid (Devexpress) and a TEDBQuery as source. I
use to change "order by" (with close and open) SQL on the fly on colunm
header click and it works well. Work well and performance are good when
scroll and  fetch records. But incremental search in grid don't work. PC
hang up. If  i use an external WWincremetalsearch components, it work. But
searches in cxgrid don't work with TEDBQuery. >>

Do you have the grid working in dataset mode (like the normal TDBGrid) or is
it loading all of the rows at once ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,
Dataset mode (gridmode = true).
In the same way, DBISAM works great. It's a grid on big dataset (Sensite an
readonly query in EDB) where I change sort order (change "order by clause"
in SQL, close and reopen) and must search data (incremental search) ,
without load all data in a "canned" query and without load all data in the
cxgrid. This is the master grid for remote/multiuser (300 user) environment,
so resources and  performances are very important.
Thanks,
Stefano




"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> ha scritto nel
messaggio news:17D69845-3227-49FD-82E2-2AFD7913998B@news.elevatesoft.com...
> Stefano,
>
> << I have a problem with cxgrid (Devexpress) and a TEDBQuery as source. I
> use to change "order by" (with close and open) SQL on the fly on colunm
> header click and it works well. Work well and performance are good when
> scroll and  fetch records. But incremental search in grid don't work. PC
> hang up. If  i use an external WWincremetalsearch components, it work. But
> searches in cxgrid don't work with TEDBQuery. >>
>
> Do you have the grid working in dataset mode (like the normal TDBGrid) or
> is it loading all of the rows at once ?
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Stefano,

> But searches in
> cxgrid don't work with TEDBQuery.
> Any workaround? Any suggestion?

The incremental search works with GridMode = True, but if the required
data is not present in the DataController cache, cxGrid will load more
data until the record has been found.

With large tables that can make things ultra-slow looking like a crash.

Generally it's never necessary to display all records of a big databaset
in a grid. You could use an edit-control instead and write some code to
search in your dataset. If all indexes are set properly, that should be
very fast.

Regards Uli

Yes, Uli. It's true. It's not  crash but ultra-slow  search;
But with DBIsam (table) all works well. I use it for a lot of applications
and all work very well (a lot of customers use this approach)
Yes, Gridmode is alway True.
Thanks, Uli.

"Uli Becker" <test@test.com> ha scritto nel messaggio
news:B6EE9640-9360-427C-A8EE-0C2BAB0CE925@news.elevatesoft.com...
> Stefano,
>
> > But searches in
>> cxgrid don't work with TEDBQuery.
>> Any workaround? Any suggestion?
>
> The incremental search works with GridMode = True, but if the required
> data is not present in the DataController cache, cxGrid will load more
> data until the record has been found.
>
> With large tables that can make things ultra-slow looking like a crash.
>
> Generally it's never necessary to display all records of a big databaset
> in a grid. You could use an edit-control instead and write some code to
> search in your dataset. If all indexes are set properly, that should be
> very fast.
>
> Regards Uli
>

Stefano,

<< Yes, Uli. It's true. It's not  crash but ultra-slow  search; But with
DBIsam (table) all works well. I use it for a lot of applications and all
work very well (a lot of customers use this approach)Yes, Gridmode is alway
True. >>

Two things:  are you using the ElevateDB Server, and are you sure that there
is a proper index that matches the column(s) that you're searching on ?
More than likely, the CXGrid uses Locate for incremental searches, and
Locate will need to have an index in order to quickly find the correct rows.

The EDB Manager uses Locate for its search function, so a good test (for
comparison purposes) is to try the same type of search against the same
table in the EDB Manager.  If it works fast there, then something else is
wrong.

--
Tim Young
Elevate Software
www.elevatesoft.com

Stefano ,

maybe you get some useful information here:

http://www.elevatesoft.com/forums?action=view&category=dbisam&id=dbisam_general&page=21&msg=60984#60984

Regards Uli