Posted by Dikkie Dik on 04/05/06 09:02

> Any pain that you have gone through? We will have some relatively high
> load, and complex queries going through the database driver.


If you know where the pain is, there must be ways to relieve it.
For complex queries, there are a few options:
- You could put them in stored procedures. This will cause the parsing
of the queries to be dropped at runtime (it was done at create time and
stored).
- If you are used to object orientation, you could implement some lazy
table wrappers for records that are part of many queries.

Best regards

[Back to original message]