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
