SE vs OnLine results question
Posted in 1992
I'm the guy that said I was going to be comparing OL vs SE. I've got some preliminary results back from the first test suite and it has raised some questions. I created a test script that would create, load, and index 4 tables. This would test insert and index performance. The insert performance was consistently worse in Online (12-75% depending on the bytes/row - the larger, the worse). The wierd things is that as I added indexes, the gains that OnLine brought diminished. It went like this: Table # Indexes Pct Faster 1 4 +265 2 8 +82 3 8 +44 4 2 -22 I declared rootdbs to be 20M and the testdbs to be 171M. They share a 191M drive. The tables take up 71M. All of the indexes are unique. My question to the OnLine heads: Is there an obvious fundamental flaw in my setup that is causing the indexing performance to degrade? I need to know ASAP as it might invalidate all further tests. - john (john%elsouth@concert.net)