Correct, I just found out that although it is possible to encode binary in javascript strings its unfortunately not possible in JSON.<br><br>You could output from mysql in HEX form using the built in function, and de-hex in a lua module? But yes that would add computational overhead.<br>
<br><div class="gmail_quote">On Wed, Jun 1, 2011 at 12:48 AM, csg <span dir="ltr"><<a href="mailto:nginx-forum@nginx.us">nginx-forum@nginx.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
SplitIce Wrote:<br>
-------------------------------------------------------<br>
<div class="im">> The largest<br>
> disadvantage is the size of the table.<br>
<br>
</div>This can be easily avoided by sharding the data into many tables,<br>
accessing it per modulo operation on the numerical key.<br>
<div class="im"><br>
> Oh and JSON<br>
> can be binary safe if<br>
> implmented correctly with correct escape<br>
> sequences, yes?<br>
<br>
</div>But this would require -- if I am not mistaken -- to touch all data end<br>
encode it with Base64 (or similar) which gives you computation and data<br>
capacity overhead. Additionally this would require changes to<br>
application which we are trying to avoid. Some component inbetwen like<br>
MySQL Proxy might be able to workaround this, but this increases latency<br>
which is also not desired.<br>
<br>
Posted at Nginx Forum: <a href="http://forum.nginx.org/read.php?2,202577,202651#msg-202651" target="_blank">http://forum.nginx.org/read.php?2,202577,202651#msg-202651</a><br>
<div><div></div><div class="h5"><br>
<br>
_______________________________________________<br>
nginx mailing list<br>
<a href="mailto:nginx@nginx.org">nginx@nginx.org</a><br>
<a href="http://nginx.org/mailman/listinfo/nginx" target="_blank">http://nginx.org/mailman/listinfo/nginx</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br><a href="http://thewarezscene.org" target="_blank">Warez Scene</a> <a href="http://www.nexusddl.com" target="_blank">Free Rapidshare Downloads</a><br><br>