Could you tell us what you've done in the DB Procedure to fetch the rows? Or is it a simple procedure that returns a result set?
Regards Alexander Schröder SAP DB, SAP Labs Berlin -----Original Message----- From: Xavier CAMIER [mailto:[EMAIL PROTECTED] Sent: Montag, 12. September 2005 10:54 To: maxdb@lists.mysql.com Subject: SELECT from a DBPROC or from Code ? 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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
