Hi!
Is there any reason you could not have used a blob with a prefix
index? How big was the binary data you inserted?
BTW on a related note would you have a good example of a URL type we
could just add?
Cheers,
-Brian
On Oct 10, 2008, at 1:06 AM, Kazuho Oku wrote:
Hi,
We run a web service called Pathtraq (http://pathtraq.com/) which is
one of the largest web access stats service in Japan above MySQL, and
it relies heavily on varbinary columns.
We are storing tens of millions of URLs in compressed form (using a
variant of static PPM compression algorithm) in a varbinary column.
Since PPM compression preserves the order of original text, we can set
indexes on varbinary columns to do a prefix search on URLs without
uncompressing them, and it does save a lot of CPU cycles and I/O.
You can find more information on the slides I used at YAPC::Asia Tokyo
2008 (around pp.17-27).
http://www.slideshare.net/kazuho/yapcasia-2008-tokyo-pathtraq-building-a-computationcentric-web-service
2008/10/10 Brian Aker <[EMAIL PROTECTED]>:
Hi!
On Oct 9, 2008, at 6:16 PM, Jim Starkey wrote:
problematic (a useful term, not strictly synonymous with bullshit).
That is my take... but I am wondering why it was added. Maybe
someone on the
list has a use-case I've never thought of.
To me binary objects are unstructured data which to me means "blob".
Cheers,
-Bria
--
_______________________________________________________
Brian "Krow" Aker, brian at tangent.org
Seattle, Washington
http://krow.net/ <-- Me
http://tangent.org/ <-- Software
_______________________________________________________
You can't grep a dead tree.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
--
Kazuho Oku
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
--
_______________________________________________________
Brian "Krow" Aker, brian at tangent.org
Seattle, Washington
http://krow.net/ <-- Me
http://tangent.org/ <-- Software
_______________________________________________________
You can't grep a dead tree.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
