Mike, I have a customer who did a comparison of Cache, Oracle and MySql. Oracle did not make it out of the gate and MySql did not meet the minimum requirements for the bench mark. The benchmark used a java front end to feed the database via jdbc. The Java program that imported the data to the database must process the large flow of data generated by the system in near real-time, while responding to a variety of queries from the servlet engine. The application had been running using MySql for several years, but as data volume increased, problems with data purging and database reliability required excessive manual intervention. Minimum insert rates had to be sustained at around 540 per second while deletes occurred and other request happened. ONLY Cache was able to produce acceptable results Cache was able to sustain the system at over 1600 inserts per second while purging data. MySql could not do both and Oracle could not achieve the minuum insert rate. Granted this was a limited app, but it is metrics.
HTH Jim Pietila InterSystems "Michael Pike" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Has anyone done any benchmarks regarding MySQL vs Cache? > > If so, what were the results? > > Thanks, > Mike >
