View unanswered posts | View active topics It is currently Sat May 18, 2013 7:45 am



Reply to topic  [ 31 posts ]  Go to page Previous  1, 2, 3, 4  Next
GRID vs. BROWSE - which control is faster? 
Author Message
User avatar

Joined: Wed Sep 08, 2010 1:18 pm
Posts: 540
Location: Paranaguá - Brasil
Post 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.

Rathinagiri wrote:
bpd2000 wrote:
Any example / sample program using IMHO virtual grid
Please see HMG main folder/samples/grid.01 to grid.38 demo folders
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
Profile
User avatar

Joined: Wed Sep 08, 2010 1:18 pm
Posts: 540
Location: Paranaguá - Brasil
Post 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_1

But I am still do not found a way to remake the array.

Marek wrote:
I have no time to analyze h_grid.prg source file.
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
Profile
User avatar

Joined: Thu Sep 11, 2008 5:31 am
Posts: 1450
Location: Myszków, Poland
Post 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
Profile WWW
User avatar

Joined: Wed Sep 08, 2010 1:18 pm
Posts: 540
Location: Paranaguá - Brasil
Post 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
Profile
User avatar

Joined: Sat Nov 13, 2010 7:27 am
Posts: 68
Post Re: GRID vs. BROWSE - which control is faster?
mol wrote:
I'm still using Browse. It works quite good to me and causes no problems with filters, changing indexes etc.

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
Profile

Joined: Thu Jun 16, 2011 10:58 am
Posts: 14
Post 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:
Image

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:
Image

for changing pointer in GRID/BROWSE I use this code:
Code:
               if lGridControlMode
         SetProperty(cOkno,"B_Towary","RECNO", towary->(Recno()))
      else 
                        //lBrowseControlMode
         SetProperty(cOkno,"B_Towary","Value", towary->(Recno()))
      endif



What's wrong with me or GRID???


Mon May 28, 2012 6:43 pm
Profile
User avatar

Joined: Thu Sep 11, 2008 5:31 am
Posts: 1450
Location: Myszków, Poland
Post Re: GRID vs. BROWSE - which control is faster?
Hej,
chyba napisałeś odpowiedź w środku mojego posta :lol:
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 :lol:
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
Profile WWW

Joined: Thu Jun 16, 2011 10:58 am
Posts: 14
Post 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
Profile
User avatar

Joined: Thu Sep 11, 2008 5:31 am
Posts: 1450
Location: Myszków, Poland
Post 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
Profile WWW

Joined: Mon Feb 13, 2012 2:41 pm
Posts: 3
Post 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
Profile
Display posts from previous:  Sort by  
Reply to topic 
 [ 31 posts ]  Go to page Previous  1, 2, 3, 4  Next

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

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.