<!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/4.0.1">
</HEAD>
<BODY>
Hi,<BR>
<BR>
The previous check-in on the branch (5cd87175faa97161023c37e2cc0f0c064e08d571) made the SQL buffer size configurable for all DBs.<BR>
<BR>
This change:<BR>
- makes the MySQL table definition use MEDIUMBLOB (up to 16M) where previously it was a BLOB (up to 64k)<BR>
- increases the size of an internal buffer in xcap_server<BR>
<BR>
The PostgreSQL table definition already uses BYTEA which does not appear to have a maximum size limit. As such, the combination of the previous commit and this change to xcap_server means you can store bigger documents with PostgreSQL. This PostgreSQL usage has been tested here at Crocodile.<BR>
<BR>
Peter<BR>
<BR>
On Wed, 2011-07-27 at 14:05 +0200, Klaus Darilion wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
Am 27.07.2011 13:16, schrieb Peter Dunkley:
> Module: sip-router
> Branch: pd/crocodile
> Commit: 6033da2e644ccdca7fa57bee03f82cb03c36e45e
> URL: <A HREF="http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=6033da2e644ccdca7fa57bee03f82cb03c36e45e">http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=6033da2e644ccdca7fa57bee03f82cb03c36e45e</A>
>
> Author: pd <<A HREF="mailto:peter.dunkley@crocodile-rcs.com">peter.dunkley@crocodile-rcs.com</A>>
> Committer: pd <<A HREF="mailto:peter.dunkley@crocodile-rcs.com">peter.dunkley@crocodile-rcs.com</A>>
> Date: Wed Jul 27 12:13:25 2011 +0100
>
> srdb1, modules_k/xcap_server: Added support for XML documents larger than 64k in MySQL
Can this be done for postgresql too?
regards
klaus
_______________________________________________
sr-dev mailing list
<A HREF="mailto:sr-dev@lists.sip-router.org">sr-dev@lists.sip-router.org</A>
<A HREF="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev</A>
</PRE>
</BLOCKQUOTE>
<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<PRE>
--
Peter Dunkley
Technical Director
Crocodile RCS Ltd
</PRE>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>