problem with updating command

[pamtru]

Hi i have a problem when running this query in shared mode or set exclu off.



update table set field=5



It is very slow in a network or mapped drive. The crazy thing is that if the mapped drive is pointing to a directory in the local computer it is very slow too. Example



use c:\table shared



update table set field=5



this go allright but now let suppose that i shared the folder where my database is and my ip is 192.168.1.1 (opening from the same computer where the database are)



use \\192.168.1.1\table shared

update table set field=5



it is very slow any idea????. This occurs in vfp6 and 9 either.



Thanks

Pamela

 

[NasibKalsi]

* The program may look like this

*
* Snipet to be run on ther server via scheduler
*

use trans in 0 shared alias trans
select trans
if UPDATENOW
use maintable in 0 shared
select maintable
replace all FIELD1 with trans.FIELD1 ConditionIfAny any condition
use
sele trans
replace UPDATENOW with .f.
endif
close data
quit

 

[pamtru]

Thanks to all for helping me. i will use vfpserver because only 1 person use the form that have the update command and i only have to make little changes to the code.. Well i hope this can help other people too.

Thanks again
Pamela