We are running a giant databse build under a two 64bits Itanuim II - that have sloved such problmes as ou data us fully text ! You could have that push through :
- Indexing the items without the need for further tables.
- Using FTS (full text search) it really improves perfomances.
- take a look at your schema.
- Using more and more Functions, triggers and rules.