|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
SELECT from a DBPROC or from Code ?
From: Xavier CAMIER (xavier.camier
batinor.fr)
Date: Mon Sep 12 2005 - 03:53:51 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Good morning,
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 ?
Kind regards
Xavier
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]