Re: Synonyms

Audie Wright wrote: > > How much extra load on the optimizer and engine would creating > synonyms create that point to different databases? Not much. > Also would there be any difference in performance from using standard > SQL to point to different databases, as opposed to using the synonyms > in the SQL to do the same thing? Not really, it must be about one read. You could always benchmark it, but I have never seen a difference in performance. If your synonyms are a large linked list, then obviously going straight to the target machine will be quicker than chaining through each machine in the list. Hope that helps, -- Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+