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

[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]

Thanks Mol

[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

[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.

[dragancesu]

Yes, it's slow

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

[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

[trmpluym]

I solved the problem moving over to LetoDB, see:

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