… bigger than original data. LucidDB Here it took time to find how to execute command from command line using included sqlline… am using c*1000/c2 here, because MonetDB seems using integer arithmetic and, with c/c2 I received just 1. So… if you want to compare or get info about air performance.
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 3 Comments
… bit of simplification but it should be enough to understand performance implications of this approach. Note trailing spaces for strings are… need to scan keyblock from the start uncompressing keys to find matching key value. This means the following will apply: Forward… times faster. With PACK_KEYS=1 we got join by integer key performing almost 5 times slower than it was – this is…
Post: Using CHAR keys for joins, how much is the overhead ?
June 18, 2007 By 18 Comments
… avoid sending data to the client Do not try to find any good meaning for query or schema. For joins which… keys. The performance dropped down to 6.1 seconds which makes it over 2 times slower compared to integer based join. So how do I read these results ? CHAR keys are indeed slower for joins compared to integer keys Performance…
Post: To UUID or not to UUID ?
March 13, 2007 By 28 Comments
…the same point – be careful applying benchmarks you find in the Internet to your own case, it…are: I’ve created MyISAM tables containing just integer auto_increment primary key and containing char(36)… this little case we have about 200 times performance difference which is worth to consider Can UUID…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… are done specially for Falcon you might find those aspects positive. [-] No Spinlocks Falcon does … Huge indexes is where large portion of Innodb performance problems come however. We should however see how … for example using only as many bytes for integer as it requires, not storing column value …
Comment: How to find wrong indexing with glance view
August 23, 2008 By 27 Comments
… – gender, has_foto; enums – available, looking_for, location; integer – age 3) All queries fall into X IN …understand that mysql finds one set using an index, another set and then finds records which exist … If you’re smart enough and read mysql performance related articles then you’ll store all …
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
… same one Peter wrote about recently). The client’s performance is suffering in part because of the number of…MonetDB for it). I created a table with 200 integer columns and loaded it with random numbers between 0… I had to go to the mailing lists to find the correct COPY syntax — it wasn’t that …
Comment: Integers in PHP, running with scissors, and portability
March 27, 2007 By 32 Comments
Thank you Andrew for posting your findings. I know you spent quite a while to implement it … regard. MySQL internal integer math was always 64bit even on 32bit platforms. This was a bit of performance penalty but not too…
