On 8/11/08, Brian Aker <[EMAIL PROTECTED]> wrote: > > Hi! > > So I am going through the myisam code mainly looking for casts and bad > conversions. One question I have is... do folks depend on the pack code for > myisam? Is it viable to toss this code and move on? > > I know that some people may still use it for analytics, but I am not sure > that this is all that common anymore (and it has poorer speed/performance > then Archive, but still has indexes so needle in a haystack queries still > work well).
Not just needle in haystack queries, but range searches as well. My vote is to keep, ARCHIVE is used in the real world more for logging things which shouldn't be modified as per compliance standards, compressed MyISAM tables are used for things like "a list of all the cities in the world" and "apache logs" and stuff.....mostly because MyISAM tables can be used with MERGE. Any feelings? > > Cheers, > -Brian > > -- > _______________________________________________________ > 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<https://launchpad.net/%7Edrizzle-discuss> > Post to : [email protected] > Unsubscribe : > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > More help : https://help.launchpad.net/ListHelp > -- - Sheeri K. Cabral Note: Currently I work for The Pythian Group (http://www.pythian.com/ ), a remote DBA firm, and consulting would constitute a conflict of interest. However, I do recommend our work, and if you're looking for DBA work (I do MySQL work, but they have great Oracle and SQL Server DBAs too) right now, whether you need a few hours a week, or someone fulltime while you continue a job search. I have a webpage with tips on how to find a DBA: http://sheeri.net/how-to-find-a-dba/ I can recommend http://www.toomanyconnections.com as a good site to find MySQL (and Oracle) DBAs. If you're looking for web design, I recommend the small business my husband works for, http://www.digital-loom.com I regret that I have no other information for any other type of position, including developer, programmer and systems administrator.
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
