[cisco-voip] redirect admin:run sql to a file

[Ryan Ratliff]

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.

-Ryan

On May 14, 2008, at 5:59 PM, Wes Sisk wrote:

Hi Mord,

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.

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.

Regards,
Wes


Mordechai wrote:
>
> 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.
>
>
>
> Regards,
>
> Mord
>
>
>
> From: Wes Sisk [mailto:wsisk at cisco.com]
> Sent: Wednesday, May 14, 2008 3:30 PM
> To: Mordechai
> Cc: cisco-voip at puck.nether.net
> Subject: Re: [cisco-voip] redirect admin:run sql to a file
>
>
>
> 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.
>
> Regards,
> Wes
>
> Mordechai wrote:
>
> Hello,
>
>
>
> Anyone knows how (if) to redirect run sql command output to a file  
> instead of screen?
>
>
>
> I can use AXL but am not sure how it is going to handle large  
> volume response.
>
>
>
> Thanks in advance,
>
>
>
> Mord,
>
> NetVision Expert Solutions Inc.
>
> m.rabinovich at nves.ca
>
>
>
>
>
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date:  
> 5/14/2008 7:49 AM
>
>
>
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date:  
> 5/14/2008 7:49 AM
>
>
>
>
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date:  
> 5/14/2008 7:49 AM
>
>
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.16/1432 - Release Date:  
> 5/14/2008 7:49 AM
>
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20080514/b847a62a/attachment-0001.html