Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>Hi Cetin
>>
>>>>>I don't understand your insistance GUID should be an SP. Do however you want.
>>>>>Cetin
>>>>
>>>Naomi,
>>>Probably you do not understand what I'm trying to say.
>>>-Keep your SP as is.
>>>-Copy functions outside to a prg also. In prg version move declaration outside generator function.
>>>-In your 'load' routines instead of leaving pk out to call default fill it from prg based one.
>>>Cetin
>>
>>This sounds like the SQL Stored Procedure Myth debates. Since the client PC is executing the VFP stored procedures, would it not be fastest of all to have these udfs compiled in the exe?
>
>Mike,
>I said no in my porevious reply, but maybe I didn't understand what you're saying:)
>What myth?
Myth that SQL Server stored procedures are always faster than dynamic SQL.
> I'm saying moving the winAPI declaration outside of generator function would speed up tens of times.
Declare before function and use by function versus declare each time function is called? Absolutely!
> Just location changing wouldn't help much I think.
It may. If the exe is local the functions contained in it would be fast. If the DBC is remote, accessing those functions *should* be slower than if they were in the exe.
Précédent
Suivant
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