how to run 2nd instance as runtime coding.

[newtofoxpro]

I have developed an application in fpw26(patched) and running on 10 Computers (Multiuser) 1 Server & 9 Clients (Nodes) having win_xp_spack2. My main_dbf having records 800,000 (1gb)approx with main_cdx index file. when ever required FOR, SQL I use index key expression for optimization. For full optimization used <index on deleted()>
Now the problem is
1) When I save entry form, required time is 15-20 sec. approx. I want to reduce it.
2) While entering entry form, I require to call some information from main_def which is in server hard drive. The information I can not call once & keep in local drive bcoz it is updating by other users.

My idea is to call sql from another instance. I got success but my main 1st instance becomes very very slow. Even I wish to run my FUNCTION form_Save from another instance in background.

Any tips for improving speed.

Regards.

 

[TamarGranor]

I don't think you need to do your query in another instance. The first thing I'd check is network traffic and speed. Those times seem slow to me.

Also, don't maintain too many indexes; each additional index does slow down an insert or update.

Tamar