Re: IDS Feature Request List (including potential new requests).

>>>
Talk to Art Kagel. He already does this kind of stuff with dynamic
names for
prepared SQL statements a feature Oracle does not have!
>>>

Seems like if people are doing this in a round about away it makes an
even stronger argument for giving them this feature so they can do it
in a straight forward way. I think it would be a win for Informix. It
is also a clear demonstration that this is a useful feature.

The problem with my application is that it uses a connection pool where
each hit to the database uses any available connection that exists.
Because prepared statements are centric to the connection and not the
server if you have 2000 connections and 25 prepared statements then you
have 50,000 prepared statements. You can create a hash map with the
statements that you have prepared and manage it for each connection
but if the server could manage this I think you would reduce the number
of prepared statements on the server side and the client side reducing
memory usage on both sides. Basically, you have a table similar to
sysprocedures and or sysprocplan where the "procedures" are basically
degenirate stored procedures that consist of 1 SQL statement that takes
a given number of parameters (prepared statement variables) which
returns the result set to the application.

Obnoxio suggested using stored procedures (in a direct email not posted
here, I guess he is being shy ;-) as a work around which is basically
how they could/should be implemented on the server side. I have had
much trouble processing multiset return values from stored procedures
in Java (if I could do this it would work as a work around but I
haven't gotten it to work). So if you know how to do this in java
please tell me and I'll use this as a work around until Informix
implements this shortly. Does Oracle own a patent on this?

Also, I haven't upgraded to 10 yet (I am running 9.21) and SSC seems to
make my server crash horribly. So I have no confidence in it.

.

Relevant Pages

  • Re: Permissions???
    ... > Server: SQL Server 2000. ... > the user could Write/Read data from server and execute stored procedures. ... > The connection was made with DSNs. ... ADO gives the following message when using stored ...
    (microsoft.public.data.ado)
  • Re: Help!!!
    ... Ensure your stored procedures include 'SET NOCOUNT ON'. ... > Server: SQL Server 2000. ... > I had an ADO conection to the from a VB Application, ... > The connection was made with DSNs. ...
    (microsoft.public.sqlserver.security)
  • Re: Can send, but cant receive email in Outlook 6
    ... It is safe to disable the message scan feature ... re-enter your password to re-establish the connection to the mail server. ... The connection to the server has failed. ... wasn't the problem causing this. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Permissions???
    ... Server: SQL Server 2000. ... I had an ADO conection to the from a VB Application, ... The connection was made with DSNs. ... Now, the system has a huge number of calls, updates and stored procedures, ...
    (microsoft.public.data.ado)
  • Re: RPC over HTTP
    ... RPC over HTTP is a great feature and I use it daily. ... place of having to use a VPN connection. ... From> what I understand this will allow users to use Outlook ... > done by connecting to a front end server? ...
    (microsoft.public.exchange2000.admin)