Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
SELECT from a DBPROC or from Code ?
From: Xavier CAMIER (xavier.camierbatinor.fr)
Date: Mon Sep 12 2005 - 03:53:51 CDT
In my attempts to increase the data transfert speed between the server
and the client apps I realised that filling a grid with a huge amount of
rows was quicker when calling a SELECT statement from code than calling
a Stored Proc containing that SELECT statement. Both tests were maid
with the same server, a delphi 7 pro coded app communicating with
x_server through the ADO and ODBC stacks. I don't think such a
difference would come from the time needed to prepare the stored proc.
Does anybody have any idea about that ?
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb