>> Is MS SQL your only choice?
We use MS SQL LocalDB on the client machine - The Linked Server feature is provides a very fast transfer of required data from the primary server to the local pc.
>> Is C# your only choice?
We have have large C# and VB.net code and skills base but we are open to suggestions.
>> If it is, and you still need to execute thousands of queries, Can you utilize CLR functions in MS SQL server? Could the process be more suited to Linq?
The queries are all built dynamically at runtime and then sent to either SQL Server or Oracle or IBM DB2 or AS400 etc BUT they can ALL be entirely different in all respects.
So CLR in MS SQL wont really help an neither will Linq as it will just intoduce more overhead.
>> can you parallelize the tasks and execute asynchronously?
The queries do come in sequentially and need to be executed as such so tthere is little scope for paralel execution except for in the formulation of the query string
Also we dont want to bog down the client computer too much by occupying too many CPU cores. VFP is already very agressive on the CPU.
The existing VFP application performs exceptionally well.
The only reason for the conversion is that we need a 64 bit version of our application because it integrates with MS Office and many of our users have migrated to 64bit Office.
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