Re: join over 12 tables takes 3 secs to plan

Neil:

I think that general use of this feature should be enabled using the 
URL, not with an API call.  We use a JDBC connection pool and it will 
help tremendously to have the pool set to user server-side preparing 
without having to downcast the connection to a PG connection (which I 
think is an issue because of the facade in our connection pool code).  

The second item is that of compatibility.  If the new code cannot handle 
all statements (eg. something with a semi in it) and disable the 
generation of a 'prepare' then we cannot count on the URL functionality. 
 As I understand it, the programmer is required currently to 
enable/disable the server-side functionality by hand and only when the 
statement to be prepared is not composite (statement1; statement2; 
statement2).

But in our real-world application space, we use a connection pool with a 
facade, so getting to the actual connection to enable this is 
problematic (and forces postgresql-specific coding into our framework 
where it is not particularly welcome).  If we overcame this issue, we 
would then need to hand-manage the enable/disable to only be used when 
the statement is appropriately formulated (e.g., no semicolons in the 
statement).

If we could get URL enabling and auto-detection of statements that won't 
work (and hence disable the enabled function for these functions), I 
think we have a solution that can be deployed into 'generic' app server 
environments with just configuration changes.  That is, an operations 
person could enable this feature and monitor its impact on performance 
to see if/how it helps.  That is a BIG win (at least to me) and a HUGE 
marketing item.  I'd love to test MySQL with some joins over JDBC with 
PostgreSQL with some joins using prepared statements and be able to 
demonstrate the big improvement that this makes.

As I understand it, the functions I am waiting for are targeted into 7.4 
(but I'd love to see them early and do some testing of those for the 
community).

Charlie


Neil Conway wrote:

>On Fri, 2003-01-03 at 17:16, Charles H. Woloszynski wrote:
>  
>
>>I think the functionality is starting to become real, but it looks like 
>>it is starting with some limitations that might restricts its use from 
>>be maximally realized until 7.4 (or beyond).
>>    
>>
>
>Specifically, which limitations in this feature would you like to see
>corrected?
>
>Cheers,
>
>Neil
>  
>

-- 


Charles H. Woloszynski

ClearMetrix, Inc.
115 Research Drive
Bethlehem, PA 18015

tel: 610-419-2210 x400
fax: 240-371-3256
web: www.clearmetrix.com