Subject Re: Blob Parsing Stored Procedure
Author Milan Babuskov
--- lucas_jessee
> Probably PostgreSQL, Oracle, MySQL, and SQLServer.

Take a look at SQLAPI++ then:

http://www.sqlapi.com/

I never used it myself, but if it works like they claim it does, it
looks like a right thing for you.

> Do you mean like EXECUTE AS BLOCK and chain a bunch of INSERT INTO

No, I meant EXECUTE STATEMENT, but when I think about it, it isn't a
good idea, since you would lose benefit of prepared statements.

> That might be a worth-while exercise, just to test the performance.
> However, I've already written all of my application code using ODBC.

I doubt you'll be able to get anywhere with ODBC, but that's your call.

> It would take me several weeks to port the entire application to
> another interface.

Does the entire application have such high-performance demands?
Perhaps you could just rewrite critical parts using IBPP?

--
Milan Babuskov
http://fbexport.sourceforge.net