Grid performance terribly slow on a file share, browse works well

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

User avatar
mol
Posts: 3718
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: Grid performance terribly slow on a file share, browse works well

Post by mol »

You can only use createfolder("c:\temp").
If such a folder exists, your app does nothing, else it will create folder c:\temp
franco
Posts: 816
Joined: Sat Nov 02, 2013 5:42 am
DBs Used: DBF
Location: Canada

Re: Grid performance terribly slow on a file share, browse works well

Post by franco »

Thanks Mol
All The Best,
Franco
Canada
franco
Posts: 816
Joined: Sat Nov 02, 2013 5:42 am
DBs Used: DBF
Location: Canada

Re: Grid performance terribly slow on a file share, browse works well

Post by franco »

I have revised my original post above to a working program and have tested up to 800,000 records. Index time 1.2 seconds.
It then picks records very fast also. Now I can get back to work.
Thanks to all, Franco
All The Best,
Franco
Canada
zorpavns
Posts: 22
Joined: Tue Apr 23, 2013 10:43 am
DBs Used: DBF, SQL
Location: Novi Sad, Serbia

Re: Grid performance terribly slow on a file share, browse works well

Post by zorpavns »

why the grid slows down when it passes 35,000 syllables. When it goes to the end. he needs a few minutes to recover. Every move upstairs. refresh works slowly. It is about dbf bases and cdx indexes. Thank in advance.
User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: Grid performance terribly slow on a file share, browse works well

Post by dragancesu »

Yes, it's slow

But why show 1000+ rows on the screen? What is the purpose?
franco
Posts: 816
Joined: Sat Nov 02, 2013 5:42 am
DBs Used: DBF
Location: Canada

Re: Grid performance terribly slow on a file share, browse works well

Post by franco »

What are you using the grid for.
I use Browse for picking items and grid for working with items.
In my invoicing program I have a huge items file. To use this in a grid I use temporary indexes ( look at my former post) this works well.
On server I use original indexes but on terminals I create a temp index in a folder on the terminal.
Like use server->item. set index to server->1, server->2
index on invoicenumber to c:\myindex\temp for invoicenumber = '123'
set index to temp,1,2 (udates the original indexes)
Now the grid is only looking at a few items, and is fast.
I use browse to look up inventory items to add to invoice. I have 300,000 items in my inventory file and 400,000 items in invoiceitem file.
Hope this helps depending on what you use the grid for.
Franco
All The Best,
Franco
Canada
trmpluym
Posts: 303
Joined: Tue Jul 15, 2014 6:52 pm
Location: The Netherlands

Re: Grid performance terribly slow on a file share, browse works well

Post by trmpluym »

I solved the problem moving over to LetoDB, see:

viewtopic.php?f=5&t=5604&hilit=letodb
Post Reply