This is precisely the kind of input I was hoping would be given. Thanks very much!
-jay 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 >> > > > _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
