First of all, I´m using VFP as the front end.
=SQLEXEC("Select * from MyTable where MyTable.Field1=?MyCondition","MyView")
will return a cursor, which with a few addittional commands can be made updateable, and act much like a remote view.
I then index this cursor locally, so that I later may ask something like
this
Program loop....
...
..
IF NOT SEEK(SearchKey,"MyView","Key1")
INSERT INTO MyView...
ELSE
REPLACE MyView.CalculatedField WITH AnotherValue
ENDIF
...
..
End loop....
Issuing a TABLEUPDATE()the data are written to the server, and this is where the trouble begins.
In short, what´s taking it so long, and what can I do to speed things up?
The write operation to the server takes more than twice as long as writing to DBF style tables on a file server.
And it makes no difference if I issue the update once for the entire cursor or one record at the time.
Now, there is a clustered PK, but still...
Does SQL 7.0 write to a transaction log during this task?
And is there a way to turn the logging off?
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)