Thanks Mark. I was hoping it worked that way! It wouldn't make sense to have to recompile your whole library every time you ran an analyze. :-) Sue
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark H. Wood Sent: Thursday, August 14, 2008 8:24 AM To: [email protected] Subject: Re: [Dspace-tech] performance question The query optimizer is entirely within the DBMS. Rebuilding DSpace won't affect it. The queries will be unchanged; VACUUM ANALYZE just updates statistics within the database which the optimizer uses to decide, on the fly, how to execute a query most efficiently. -- Mark H. Wood, Lead System Programmer [EMAIL PROTECTED] There's more than one way to do it -- also the Perl motto ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
