Walter Meester
HoogkarspelNetherlands
General information
Category:
Coding, syntax & commands
Kevin,
Unfortunately its is not that simple though as the origninal schema was a simplified one and the actual code deals with some other details as well. In short it is going to take way more time to have two identical examples as the VFP code is not complete and won't work as presented.
It was merely shown as a example what I mean with data munging and the level of complexity. You're free to create a .NET example one, and I'm sure you can come up with something similar, though it will take up many more lines and is even harder (which is the point I've been making).
A SP example is far more challenging though as the munging is done record by record with a lot more complex calculation that is way more difficult to do in T-SQL. And of course that is what this topic is about. Munging on the SQL server in a SP.
Walter,
>OK, that's great, thanks.
>
>I'll create sample data. You gave me general row counts before, so I will see what I can do to generate test data with those rows counts.
>
>Ideally, I'd like to do two examples -
>
>the first will use the same two queries that you have for RES1 and RES2, and then I'll write the data munging in ADO.NET. This will demonstrate how ADO.NET can be used. After I get some sample data loaded, I'll time the two processes [VFP and .NET].
>
>The second example will try to put more of the data summarization into a stored procedure, with limited munging.
>
>This will take some time, as I'm working on other things, but I'll certainly have this done before the end of the month, if not before.
>
>Thanks for posting the code, I appreciate it. I'll try to limit my questions, but I may have a few as I go through this.
>
>Kevin
Previous
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