Search found 227 matches

by franco
Tue Feb 13, 2018 5:58 am
Forum: HMG General Help
Topic: Grid performance terribly slow on a file share, browse works well
Replies: 32
Views: 1953

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
by franco
Mon Feb 12, 2018 6:02 pm
Forum: HMG General Help
Topic: Grid performance terribly slow on a file share, browse works well
Replies: 32
Views: 1953

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

I am trying to check to see if there is a folder for the demo above. Can not figure out as I can keep creating a folder and it works but if the folder exists I should not create need to create it. Like this: if ! folder("c:\temp") \\ this does not work createfolder("c:\temp") \\this works endif I kn...
by franco
Sun Feb 11, 2018 5:20 pm
Forum: HMG General Help
Topic: Grid performance terribly slow on a file share, browse works well
Replies: 32
Views: 1953

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

I dreamed last night what Mol mentioned. And now have it fixed. I do not add records in my browse function. In my server computer I have a unique folder SEND, so if this folder does not exist in a terminal and reccount() > 1000 which seems to be the slowing point, then I create temp index to a folde...
by franco
Sun Feb 11, 2018 7:20 am
Forum: HMG General Help
Topic: Grid performance terribly slow on a file share, browse works well
Replies: 32
Views: 1953

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

SERGE, and APAIS, Thanks for help. I revised the program above and it works perfectly. This is a good answer for this dilemma. Create a local index as Serge suggested. Now I could not make a memio index. Do you know how. I tried REQUEST HB_MEMIO USE INV Do not know how to create index in memory, the...
by franco
Sat Feb 10, 2018 9:56 pm
Forum: HMG General Help
Topic: Grid performance terribly slow on a file share, browse works well
Replies: 32
Views: 1953

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

Hi Serge, Can we create a index into local memory, then when finished and closing tables, release the index. I map network drive, then go to drive and send the exe to desktop. so tables are in main drive but program in this computer, so when going into invoicing program I would have to create a loca...
by franco
Sat Feb 10, 2018 6:48 pm
Forum: HMG General Help
Topic: Grid performance terribly slow on a file share, browse works well
Replies: 32
Views: 1953

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

Here is a small sample of my problem. When there are 1000 items not to much problem but when large table big problem. If you compile this and run on one computer it runs good, but if you map a network drive from another computer to computer where program is and is already running in the grid it is r...
by franco
Wed Feb 07, 2018 10:00 pm
Forum: HMG General Help
Topic: Grid performance terribly slow on a file share, browse works well
Replies: 32
Views: 1953

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

Theo, I am lost when adding things like this. Can you help me. Ido not know where to start.
Thanks, Franco
by franco
Wed Feb 07, 2018 7:04 pm
Forum: HMG General Help
Topic: Grid performance terribly slow on a file share, browse works well
Replies: 32
Views: 1953

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

I am using a browse to look up inventory items for my grid. I have a textbox to type into to update the browse. windows sharing. This works well on a workstation if server is not in use, but is really to slow when server starts to do anything. In this dbf table there are 150,000 items and I use a nt...
by franco
Wed Feb 07, 2018 6:51 pm
Forum: Self Introduction
Topic: I want to be a HMG Poster
Replies: 497
Views: 72660

Re: I want to be a HMG Poster

Hi all, In early 80`s I could not afford or get a pos system. had to create files and indexs COMMODORE 64.
Franco,