Hi Rick.
I've tested using sqlexec() but got the same poor results. I'm looking for some sort of config issue ... the curious part is that the c++ app inserts new records with memo data just fine... so, I'm trying to determine what VFP might be doing that could cause the sql server to act in this fashion.
Thx for you input.
Scott.
ps; What's the latest web connect version at this time? I haven't looked at one of my projects using this in a while and I should get back to it soon....see what's what ... what might be done differently.
>First thing I would do is see if you have a SQL Server config problem of some
>sort. Easiest way to check is skip the remote view and directly update your
>database with a SQLExecute().
>
>Lots of overhead with remote views especially if they're large and not
>properly filtered. On update intensive apps I'd highly recommend using
>straight SQL commands if performance is your main goal.
>
>+++ Rick ---
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement