… CPU frequency alone (2600Mhz vs 2800Mhz) and it … tuning for Benchmark which could be performed on database engine …benchmarks in the difference conditions but my expectations would be getting at least 800 JOPS on updated…non transactional MyISAM, Multi Value inserts, Query Cache, Merge Tables, …
Post: Tokyo Tyrant - The Extras Part I : Is it Durable?
November 10, 2009 By 5 Comments
…tcrdbsync’ is used in order to synchronize updated contents of a remote database object with the file and the …in my benchmark, heavy write operations will see a drop in performance… for instance with 8 threads simply update/inserting … needed to ensure you have the proper recovery -vs- performance …
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…different queries. First favorite query for any database benchmarker is SELECT count(*) FROM ontime;. Both …: This experiment was not really about InfoBright vs MonetDB comparison. My goal was to …you only LOAD DATA. InfoBright Enterprise allows INSERT / UPDATE but that also is not for online…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
…Database Service (RDS) is a cloud-hosted …as famously happens in B-Tree inserts (see InnoDB vs TokuDB for example). This doesn’… we need a multi-threaded long-term insert benchmark such as IIBench. In the next … various thread counts on the OLTP benchmark. Update Vadim and Peter have rightly pointed …
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… MySQL database or else periodically batch-insert data that has changed since last time you updated the index… Q: What about MemSQL and indexes. Have you benchmarked it? According to their documentation, MemSQL supports… MySQL vs Solr. I was able to index all the data from the database into Solr…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… would write at 100MBps vs 33MBps. Any plans to…INSERT with multiple values? We build up INSERTS on our clients and insert…the option. Here are some benchmarks we did. Q24: INNODB … to other database brands. Maybe in some denormalized database (for example… portion of the questions. UPDATE: Second Part …
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
…oriented database I’ve been meaning to take a look at? What follows is not a realistic benchmark…wanted to see how fast MyISAM vs. MonetDB would interpret really large INSERT statements, the kind produced by…no REPLACE, and there is no INSERT/ON DUPLICATE KEY UPDATE.) I didn’t try the XQuery interface…
