<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
If you are doing user queries be particularly careful as it has been known to cause Tomcat to run out of memory when returning large numbers of users. <div><br><div> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica">-Ryan</font></p> </div><br><div><div>On May 14, 2008, at 5:59 PM, Wes Sisk wrote:</div><br class="Apple-interchange-newline"> Hi Mord,<br> <br> What are you querying that is going to generate 20K records? My only guess would be CDR data. If so, doing it from CLI or AXL will have the same result. Informix has not been a strong point of the 5.x/6.x platform so I would also be very concerned about performance impact. 20k records would very much be an off hours activity.<br> <br> If you are looking to retrive CDR data then have a look at the CAR interface. It includes an item to export CDR's. Very conventient for a post mortem analysis.<br> <br> Regards,<br> Wes<br> <br> <br> Mordechai wrote: <blockquote cite="mid:010901c8b5fa$d6b8b5e0$a10a5c0a@t41" type="cite"> <!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--> <!--[if gte mso 9]><xml> <o:shapedefaults v:ext="edit" spidmax="1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext="edit"> <o:idmap v:ext="edit" data="1" /> </o:shapelayout></xml><![endif]--> <div class="Section1"><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Wes, thanks for the VERY quick response. In your experience, would there be an impact if the response generates over 20K records? I am reluctant to experiment in production and the lab has only a few dozen users/phones.<o:p></o:p></span></font></p><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></p><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Regards,<o:p></o:p></span></font></p><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Mord<o:p></o:p></span></font></p><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></p> <div> <div class="MsoNormal" style="text-align: center;" align="center"><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt; color: windowtext;"> <hr tabindex="-1" align="center" size="2" width="100%"></span></font></div><p class="MsoNormal"><b><font color="black" face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; color: windowtext; font-weight: bold;">From:</span></font></b><font color="black" face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; color: windowtext;"> Wes Sisk [<a class="moz-txt-link-freetext" href="mailto:wsisk@cisco.com">mailto:wsisk@cisco.com</a>] <br> <b><span style="font-weight: bold;">Sent:</span></b> Wednesday, May 14, 2008 3:30 PM<br> <b><span style="font-weight: bold;">To:</span></b> Mordechai<br> <b><span style="font-weight: bold;">Cc:</span></b> <a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [cisco-voip] redirect admin:run sql to a file</span></font><font color="black"><span style="color: windowtext;"><o:p></o:p></span></font></p> </div><p class="MsoNormal"><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt;"><o:p> </o:p></span></font></p><p class="MsoNormal"><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt;">AXL is preferred interface for any type of systemic updates. CLI is for troubleshooting purposes only. The CLI is also subject to change at any time without notice or warning. Whereas AXL is at least tested for backward compatibility.<br> <br> Regards,<br> Wes<br> <br> Mordechai wrote: <o:p></o:p></span></font></p><p class="MsoNormal"><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Hello,<u1:p></u1:p></span></font><o:p></o:p></p><p class="MsoNormal"><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"><u1:p> </u1:p></span></font><o:p></o:p></p><p class="MsoNormal"><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Anyone knows how (if) to redirect run sql command output to a file instead of screen? <u1:p></u1:p></span></font><o:p></o:p></p><p class="MsoNormal"><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"><u1:p> </u1:p></span></font><o:p></o:p></p><p class="MsoNormal"><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">I can use AXL but am not sure how it is going to handle large volume response. <u1:p></u1:p></span></font><o:p></o:p></p><p class="MsoNormal"><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"><u1:p> </u1:p></span></font><o:p></o:p></p><p class="MsoNormal"><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Thanks in advance,<u1:p></u1:p></span></font><o:p></o:p></p><p class="MsoNormal"><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"><u1:p> </u1:p></span></font><o:p></o:p></p><p class="MsoNormal"><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Mord,<u1:p></u1:p></span></font><o:p></o:p></p><p class="MsoNormal"><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">NetVision Expert Solutions Inc.<u1:p></u1:p></span></font><o:p></o:p></p><p class="MsoNormal"><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"><a moz-do-not-send="true" href="mailto:m.rabinovich@nves.ca">m.rabinovich@nves.ca</a><u1:p></u1:p></span></font><o:p></o:p></p><p class="MsoNormal"><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt;"><u1:p> </u1:p><o:p></o:p></span></font></p><p class="MsoNormal"><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt;"><o:p> </o:p></span></font></p><p><font color="black" face="Times New Roman" size="2"><span style="font-size: 10pt;">No virus found in this outgoing message.<br> Checked by AVG.<br> Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date: 5/14/2008 7:49 AM</span></font><o:p></o:p></p><p class="MsoNormal"><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt;"><o:p> </o:p></span></font></p><p><font color="black" face="Times New Roman" size="2"><span style="font-size: 10pt;">No virus found in this outgoing message.<br> Checked by AVG.<br> Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date: 5/14/2008 7:49 AM</span></font><o:p></o:p></p> <pre wrap=""><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"><o:p> </o:p></span></font></pre> <pre style="text-align: center;"><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"><hr align="center" size="4" width="90%">
</span></font></pre> <pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"><o:p> </o:p></span></font></pre> <pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">_______________________________________________<o:p></o:p></span></font></pre> <pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">cisco-voip mailing list<o:p></o:p></span></font></pre> <pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"><a moz-do-not-send="true" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><o:p></o:p></span></font></pre> <pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"><a moz-do-not-send="true" href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a><o:p></o:p></span></font></pre> <pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> <o:p></o:p></span></font></pre> </div> <br><p><font size="2">No virus found in this incoming message.<br> Checked by AVG.<br> Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date: 5/14/2008 7:49 AM<br> </font> </p> <br><p><font size="2">No virus found in this outgoing message.<br> Checked by AVG.<br> Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date: 5/14/2008 7:49 AM<br> </font> </p> </blockquote><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">cisco-voip mailing list</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><a href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a></div> </div><br></div></body></html>