Page 4 of 4

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

Posted: Mon Feb 12, 2018 6:27 pm
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

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

Posted: Mon Feb 12, 2018 6:33 pm
by franco
Thanks Mol

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

Posted: Tue Feb 13, 2018 5:58 am
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

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

Posted: Tue Sep 11, 2018 7:32 am
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.

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

Posted: Tue Sep 11, 2018 11:28 am
by dragancesu
Yes, it's slow

But why show 1000+ rows on the screen? What is the purpose?

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

Posted: Thu Sep 13, 2018 4:40 pm
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

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

Posted: Sat Sep 15, 2018 2:36 pm
by trmpluym
I solved the problem moving over to LetoDB, see:

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