3 ms·
5-10 times compared to what? A flat file DB with no index performing joins as nested loops? I like DB2 express, but this is not an informative article.
by dhoe 17y ago
5-10 times compared to what? A flat file DB with no index performing joins as nested loops? I like DB2 express, but this is not an informative article.
- derwiki 17y agoI agree: "the time required to process financial month close transactions was reduced from 4-6 hours to 10-11 minutes" doesn't give any insight into how this was done, how it was set up before, etc.. On a side note, I had installed DB2 Express-C on an Ubuntu machine, did a distribution upgrade, and DB2 refused to work again. In fact, it broke in such a way that apt-get couldn't remove DB2.. and I couldn't find any information on how to fix it. It could be 10x faster than MySQL, but at least MySQL is well documented and supported and has an active community. To me, that counts for a lot.
- lpetrazickis 17y agoDid you try asking about it on the community forum? http://www.ibm.com/developerworks/forums/forum.jspa?forumID=805&start=0 http://www.ibm.com/developerworks/forums/forum.jspa?forumID=...
- derwiki 17y agoNope, but I was an IBM employee at the time (on DB2 nonetheless) and tried internal channels to no avail.
- GuyDeBedeux 17y agoThe original article is from a Russian on-line IT site. You would not expect an indepth coverage on all the feeds and speeds in an article like that. Typically you would see a statement of benefit just like they said going from 4-6 hours to do financial month close to 10-11 minutes. If you are running this company or you got paid to install this system, this is a big deal; joins as nested loops no so much. Most 1C installations of any size run on Microsoft SQL Server so it is not unreasonable to assume that that is what this customer migrated from but there is no guarantee.