I will have to look for some scripts that run for more than 30 minutes and stores rather large pieces of data in database, can someone guess what would be a good instruction mix for such a test? I think it should be based on what a rough ACS usage mix would be. I need a list like:
- 10% single table lookups
- 30% two-table joins
- 15% three-table joins
- 25% single table update
- 10% multi-table transactions
- 10% bulk full text searches
That way we can get a good idea what is good for OpenACS on different boxes. Mind you, we might end up with an advice like 'don't bother tweaking, you'll only gain 2% performance. It's cheaper to buy more RAM.'
