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
Re: Grid performance terribly slow on a file share, browse works well
Thanks Mol
All The Best,
Franco
Canada
Franco
Canada
Re: Grid performance terribly slow on a file share, browse works well
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
All The Best,
Franco
Canada
Franco
Canada
Re: Grid performance terribly slow on a file share, browse works well
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: 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
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?
Re: Grid performance terribly slow on a file share, browse works well
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
All The Best,
Franco
Canada
Franco
Canada