>Thanks you guys!
>
>I am running a program that takes about 5.5 hours... and any little thing I can do to speed it up is worthwhile.
>
>I really really really wish that ODBC writes and commits happened faster.
>
>>>I am running a program in my development environment and I was wondering fi there is any benefit to making it an app or a exe file? All the program code, forms, reports, etc are in the current directory.
>>>
>>>I'll test it myself, but I don't won't to go thru it if someone else has already.
>>>
>>>Thanks!
>>Hi Todd,
>>
>>EXEs have headers to allow them to load. APPs don't have the headers. All three contain tokenized p-code, so there shouldn't be any performance differences after the modules have been loaded.
OK, here's my take: If you are executing calls to a backend database server and the same statement is sent several times but with different parameters, then you can get some improvement if you SQLPREPARE() it. Just my .02 and HTH