GRID vs. BROWSE - which control is faster?
| Author |
Message |
|
Pablo César
Joined: Wed Sep 08, 2010 1:18 pm Posts: 540 Location: Paranaguá - Brasil
|
 GRID vs. BROWSE - which control is faster?
I am still in doubt for choosing: Grid or Browse. For me in Clipper was very usefull to use TBrowse for arrays specially when I need to change all records with its contents. For example: Browse1 showing dbf records and Browse2 showing their sons records and when changing records from Browse1 besides show their other records. In other words: List of clients with their buying orders. Examples which I have seem it was dbf-records with dbf-records and I will need array-records. Because I believe arrays manipulation is faster that fisical in dbf, specially when I have to use SET FILTER or UNIQUE. I will see VirtualGrid that Mr. Rathinagiri advised, but I am not sure how to compose arrays extracted from dbf in Virtual Grid. I have seem for virtual grid samples are from folder/samples/grid.02 to folder/samples/grid.24 not upto 38 or 39... others upper 24 are not virtual are from rowsource (from dbf). I tested normal Grid crating arrays according dbf records I show fine. But there is an combobos option that change filter and I can not remake the existing array for re-showing. I am lost at moment, I do not know what to use: backing to Browsing with dbf-records or Grid/VirtualGrid with array remaking all the time when change filter. But this last option I do not found the right way.
_________________ A hug xBase-d in HMGing You may share your doubts and solutions with all the colleagues by forum. Please do not send me PMs or eMails for technical proposes.
|
| Sun Dec 11, 2011 2:03 pm |
|
 |
|
Pablo César
Joined: Wed Sep 08, 2010 1:18 pm Posts: 540 Location: Paranaguá - Brasil
|
 GRID vs. BROWSE - which control is faster?
I have found this in \Grid FastFind\now.prg by Honorio and modified by Jacek Kubica: DELETE ITEM ALL FROM Grid_1 OF Win_1But I am still do not found a way to remake the array. I do not promise to find control faster or not. But I will look deep in h_grid.prg and find myself the solution for my case. It is incridible as important to find from the deep soul of question having the source code ! Thank you Roberto for your great idea to share with allof us ! God and all programmers bless you !
_________________ A hug xBase-d in HMGing You may share your doubts and solutions with all the colleagues by forum. Please do not send me PMs or eMails for technical proposes.
|
| Sun Dec 11, 2011 4:02 pm |
|
 |
|
mol
Joined: Thu Sep 11, 2008 5:31 am Posts: 1450 Location: Myszków, Poland
|
 Re: GRID vs. BROWSE - which control is faster?
I'm still using Browse. It works quite good to me and causes no problems with filters, changing indexes etc.
_________________ Marek Olszewski MOL-Systemy Komputerowe Marek Olszewski, Myszków, Polska legginsy, leginsy, odzież damska XXL, bluzki
|
| Mon Dec 12, 2011 6:30 am |
|
 |
|
Pablo César
Joined: Wed Sep 08, 2010 1:18 pm Posts: 540 Location: Paranaguá - Brasil
|
 GRID vs. BROWSE - which control is faster?
I have found the only example working Grids with arrays in HMG\SAMPLES\AGENDA from Humberto Fornazier which teach us how to use some "Grid" commands like these:
MODIFY CONTROL ADD ITEM DELETE ITEM
Analysing his example Agenda.prg I note that I can easy work with arrays in Grid. Was wonderful work of Mr. Humberto, now I feel much better even knowing that I was inexperienced with Grids strenght. My ignorance make me feel so "plastered" in what I tried to do. I am enjoying much this HMG... thanks again HMG team !
_________________ A hug xBase-d in HMGing You may share your doubts and solutions with all the colleagues by forum. Please do not send me PMs or eMails for technical proposes.
|
| Mon Dec 12, 2011 7:38 pm |
|
 |
|
nguyenchiduc
Joined: Sat Nov 13, 2010 7:27 am Posts: 68
|
 Re: GRID vs. BROWSE - which control is faster?
I still use the gird with a file ".Dbf" intermediate (temp) to display the results. The number of records on the server from hundreds of thousands to millions. This is not optimal but still ok
|
| Wed Jan 11, 2012 2:40 pm |
|
 |
|
fugazi
Joined: Thu Jun 16, 2011 10:58 am Posts: 14
|
 Re: GRID vs. BROWSE - which control is faster?
 |  |  |  | mol wrote: I'm using function, which realises incremental searching of data entered in "Wyszukaj" Field. Any input in "Wyszukaj" field causes DBSeek in table and changes pointer in table. No filter is set. When I present data in BROWSE control, everything works ok:  Cześć Miałem ten sam problem. Ustaw Multiselect na .F. > Set, Get Grid.Recno wtedy mi działa poprawnie. Pozdrawiam Fugazi When I present data in GRID control, it's very strange, but table shows different records than searched:  for changing pointer in GRID/BROWSE I use this code: What's wrong with me or GRID??? |  |  |  |  |
|
| Mon May 28, 2012 6:43 pm |
|
 |
|
mol
Joined: Thu Sep 11, 2008 5:31 am Posts: 1450 Location: Myszków, Poland
|
 Re: GRID vs. BROWSE - which control is faster?
Hej, chyba napisałeś odpowiedź w środku mojego posta Jak możesz, popraw, będzie łatwiej zrozumieć tekst. Choć podejrzewam, że i tam mało Polaków nas czyta. Ale niech tam, niektórzy z uporem maniaka piszą po hiszpańsku, więc niech choć trochę połamią głowę nad tym tekstem Pozdrowienia, Marek
_________________ Marek Olszewski MOL-Systemy Komputerowe Marek Olszewski, Myszków, Polska legginsy, leginsy, odzież damska XXL, bluzki
|
| Tue May 29, 2012 5:15 am |
|
 |
|
fugazi
Joined: Thu Jun 16, 2011 10:58 am Posts: 14
|
 Re: GRID vs. BROWSE - which control is faster?
Hej, Męczyłem grida parę dni, szukałem wyjaśnienia na forum dlaczego grid.recno nie zwraca i nie daje się poprawnie podstawić. Mam ustawione relacje a w columnfields wyspecyfikowane pola z wielu selectów {'decyzje->typ_fak+" "+decyzje->typ_obiekt+decyzje->rodzaj+decyzje->stan','decyzje->indeks','ALLTRIM(ludzied->nazwisko)+" "+ALLTRIM(ludzied->imie)','left(zasobyd->nazwa,40)'} Jak wyłączyłem property multiselect grid.recno działa poprawnie. Zastanawiam się do czego służy multiselect i czemu nie działa grid.recno? Pozdrawiam Fugazi P.S. W nowych postach będę po angielsku ale w odgrzewanych niech się pomęczą 
|
| Tue May 29, 2012 8:24 am |
|
 |
|
mol
Joined: Thu Sep 11, 2008 5:31 am Posts: 1450 Location: Myszków, Poland
|
 Re: GRID vs. BROWSE - which control is faster?
Myślałem, że browse spowalnia pracę programu a nie mogłem dojść końca z gridem. Miałem mało czasu, więc zostawiłem browsa. Okazało się, że przyczyna wolnej pracy leżała zupełnie gdzie indziej. Męczyłem później grida do pracy z tabelami, dość dużymi. Bardzo dobrze działa jako virtualgrid. Rewelacyjnie szybko. Ale z moich obserwacji wynik, że zakażdym razem grid jest odświeżany dwa razy - zupełnie nie wiem po co, pewnie jakiś wyjątek wyzwala drugie odświeżanie. Marek
_________________ Marek Olszewski MOL-Systemy Komputerowe Marek Olszewski, Myszków, Polska legginsy, leginsy, odzież damska XXL, bluzki
|
| Tue May 29, 2012 9:21 am |
|
 |
|
bartsoft
Joined: Mon Feb 13, 2012 2:41 pm Posts: 3
|
 Re: GRID vs. BROWSE - which control is faster?
Dołącze się do dyskusji - MultiSelect to wybór z możliwością zanaczania kilku wierszy (zwraca wtedy tablicę z rekordami)...
|
| Sun Jun 03, 2012 4:42 pm |
|
|
Who is online |
Users browsing this forum: No registered users and 1 guest |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum
|
|