<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.14.3">
</HEAD>
<BODY>
Hi,<BR>
<BR>
I wish to integrate a Microsoft SQL server with Asterisk for CDRs and for dialplan routing based on database values, and have this application scale to a large number of simultaneous calls: The Asterisk: The Future of Telephony 2nd edition book states that:<BR>
<BR>
‡ The pooling and limit options are quite useful for MS SQL Server and Sybase databases. These permit you<BR>
to establish multiple connections (up to limit connections) to a database while ensuring that each connection<BR>
has only one statement executing at once (this is due to a limitation in the protocol used by these database<BR>
servers).<BR>
<BR>
Does this suggest any kind of performance issue with scaling? I am assuming not as all this indicates is that DB queries are pooled from the ODBC connection on the Asterisk Server side rather than the SQL Server? Has anyone done this before in a large implementation?<BR>
<BR>
Any advice appreciated.<BR>
<BR>
Cheers<BR>
<BR>
Robert McNaught<BR>
<BR>
</BODY>
</HTML>