(RADIATOR) performance question

[radiator]

Hi,

on my previous question I was told to take a look at the database design
(indexes) to speed up performance.

Now what if I have just configured the radiator with the basic examples
from the goodies directory ?

In that case I have :

- an empty accounting table
- a subscribers table with just one entry

When now the radpwtst -iterations 1000 is run I guess I should see
numbers that should represent the best performance there is to achieve
because the accounting table contains NO indexes which is the fastest
for insertion of records (you don't need to update the indexes when a
record is inserted) and the subscribers table only contains 1 record so
that should not be difficult to lookup.

I found that on a Sparc Ultra-II 300  with postgresql 7.1 about 12
requests a second can be handled which is rather low. The documentation
chapter 24 says that a P-III-500 with Radhat linux does 70 requests a
second, so I guess that a Sparc-Ultra-II-300 should be able to get near
that number too.

Who would share some thoughts ?

Thanks,


Feite Brekeveld

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.