You can only use createfolder("c:\temp").
If such a folder exists, your app does nothing, else it will create folder c:\temp
Grid performance terribly slow on a file share, browse works well
Moderator: Rathinagiri
Thanks Mol
Franco Bushie
Canada
Canada
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
It then picks records very fast also. Now I can get back to work.
Thanks to all, Franco
Franco Bushie
Canada
Canada
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
- Posts: 606
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
- Has thanked: 18 times
- Been thanked: 115 times
Yes, it's slow
But why show 1000+ rows on the screen? What is the purpose?
But why show 1000+ rows on the screen? What is the purpose?
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
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
Franco Bushie
Canada
Canada