• Welcome, Guest. Please login.
 
May 26, 2019, 12:28:38 am

News:

Welcome to the SQLitening support forums!


SqliteningProc vs. client side processing - an observation

Started by Bern Ertl, June 04, 2009, 05:24:30 pm

Previous topic - Next topic

Bern Ertl

I have written a function client side that did some processing of a couple database tables and later realized that the function should have been written as a server side proc since I didn't really need to transfer any of the results to the client app (just store the results in another table for later processing).

After testing out the function and ensuring it was working correctly, I went ahead and copied/modified it to execute as a server side function (SQLiteningProc DLL) and did some testing with PowerBASIC's TIX for benchmarking.

Using the same data, the server side function was executing in roughly 1/5 the time as the equivalent client side function.  It's not really relevant to any code any of you might be writing as the difference is likely dependent upon a number of factors (including how much data is being read/written), but I thought it was interesting none-the-less that the difference could be so large.