Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only