in addition to the good advise of "materialzing the view" as in "create table <whatever> as select * from <viewwhatever>" once a day,
and to provide more information,
PLEASE take notice that
those performance-recommendations are primarly based on Unix-Systems (Linux, BSD, Solaris).
Especially shared buffers have totally different effects on win32.
Best wishes,
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!