Welcome! Log In Create A New Profile

Advanced

Re: Accessing binary blob data in MySQL backend

csg
May 31, 2011 10:48AM
SplitIce Wrote:
-------------------------------------------------------
> The largest
> disadvantage is the size of the table.

This can be easily avoided by sharding the data into many tables, accessing it per modulo operation on the numerical key.

> Oh and JSON
> can be binary safe if
> implmented correctly with correct escape
> sequences, yes?

But this would require -- if I am not mistaken -- to touch all data end encode it with Base64 (or similar) which gives you computation and data capacity overhead. Additionally this would require changes to application which we are trying to avoid. Some component inbetwen like MySQL Proxy might be able to workaround this, but this increases latency which is also not desired.
Subject Author Posted

Accessing binary blob data in MySQL backend

csg May 31, 2011 07:20AM

Re: Accessing binary blob data in MySQL backend

Igor Sysoev May 31, 2011 09:58AM

Re: Accessing binary blob data in MySQL backend

SplitIce May 31, 2011 10:08AM

Re: Accessing binary blob data in MySQL backend

Igor Sysoev May 31, 2011 10:34AM

Re: Accessing binary blob data in MySQL backend

SplitIce May 31, 2011 10:40AM

Re: Accessing binary blob data in MySQL backend

csg May 31, 2011 10:48AM

Re: Accessing binary blob data in MySQL backend

SplitIce May 31, 2011 11:32AM

Re: Accessing binary blob data in MySQL backend

csg May 31, 2011 10:42AM

Re: Accessing binary blob data in MySQL backend

mow May 31, 2011 10:54AM

Re: Accessing binary blob data in MySQL backend

csg May 31, 2011 11:05AM

Re: Accessing binary blob data in MySQL backend

Igor Sysoev May 31, 2011 11:10AM

Re: Accessing binary blob data in MySQL backend

csg May 31, 2011 11:24AM

Re: Accessing binary blob data in MySQL backend

Piotr Sikora May 31, 2011 11:52AM

Re: Accessing binary blob data in MySQL backend

agentzh June 01, 2011 12:04AM

Re: Accessing binary blob data in MySQL backend

csg June 01, 2011 02:12AM

Re: Accessing binary blob data in MySQL backend

mow May 31, 2011 11:44AM



Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 42
Record Number of Users: 6 on February 13, 2018
Record Number of Guests: 421 on December 02, 2018
Powered by nginx      Powered by FreeBSD      PHP Powered      Powered by MariaDB      ipv6 ready