Re^2: Most efficient MS SQL connection

Thanks - I will say that DB communication is a significant portion of the time (aside from the few reports that need massive hash table manipulation, which is a whole other problem). I will look and see if DBD::Sybase will work any better.

Comment on Re^2: Most efficient MS SQL connection

Replies are listed 'Best First'.
Re^3: Most efficient MS SQL connection by mje (Curate) on Mar 02, 2010 at 22:59 UTC
How did you ascertain that DB communication is a significant portion of the time? That is not my experience with DBD::ODBC and MS SQL Server with two exceptions which are a) when retrieving very large result-sets (and this could be improved by using array binding in DBD::ODBC but I've never had the impetus to do it myself) and b) when using dynamic or server-side cursors. I'd be most interested in your usage case if it really demonstrates a high proportion of the time in DB communication. Unlike some other people who claim using ODBC slows everything down (their usual reason is based on ODBC adds another layer over the TDS protocol and hence it must be slower) I've seldom seen an actual real life case with numbers that categorically proves adding ODBC makes a signifcant difference.	[reply]

Replies are listed 'Best First'.

Re^3: Most efficient MS SQL connection
by mje (Curate) on Mar 02, 2010 at 22:59 UTC

How did you ascertain that DB communication is a significant portion of the time? That is not my experience with DBD::ODBC and MS SQL Server with two exceptions which are a) when retrieving very large result-sets (and this could be improved by using array binding in DBD::ODBC but I've never had the impetus to do it myself) and b) when using dynamic or server-side cursors.

I'd be most interested in your usage case if it really demonstrates a high proportion of the time in DB communication.

Unlike some other people who claim using ODBC slows everything down (their usual reason is based on ODBC adds another layer over the TDS protocol and hence it must be slower) I've seldom seen an actual real life case with numbers that categorically proves adding ODBC makes a signifcant difference.

[reply]