> > (3) Do these motivations make sense? > > Yes and no. ;-] > > Classic does not provide the fastest performance, but it does provide the > most consistent multi-connection performance. It is currently (v3 will be > changing this) the only engine which truly scales across CPUs.
In re-reading my post, I realize that the above is not as technically correct as it should be. I should have written: Classic does not provide the fastest performance, but it does provide the most consistent multi-connection performance. It is currently (v3 will be changing this) the only engine which is able to use multi-cores/CPU to support multiple database connections* Sean * Each connection is a dedicated OS process, which the OS is able to move to free CPU resource has the load increases.
