Brian Aker wrote: > Hi! > > Is there any reason you could not have used a blob with a prefix index? > How big was the binary data you inserted?
Well... I do know that in many places blob impl is crap enough that doing varbinary for this would likely perform better... > BTW on a related note would you have a good example of a URL type we > could just add? This brings up what I was chatting about last night, which is pluggable types. And for that matter, types not being totally tied to storage mechanism. Jim keeps talking about only having a couple of basic types - for one a "bytes" type. That's great: it's how the database stores this chunk of bytes. But then if I could define a type that was "Static PPM compressed URL" that stores into a BYTES, the yippee! We've got something that defines some behavior and some constraints, and we don't have to have eleventy-billion different basic types - but people _can_ have types that make sense for them. Of course, this means that a pluggable type needs to be able to be done in a sensible way. Defining the types through SQL a-la the standard is retarded. SQL is a query language for crying out loud. > 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 > _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
