Stephen Gutknecht (SAPDB) wrote:
Normally it does: open, many queries and updates over hours, close.What does your application do ? We do a lot of web pages where you Open/Query/Close and Open/Insert/Close dozens of times a minute (sometimes hundreds).
My webapplication connects to the database and keeps the connection open between requests, the only time connections are closes is when a webserver process stops.
Do you have access to a Windows XP / Windows 2000 system
No, thank God:)
Hmm, does your server or your client get strange?I just wanted to point out that the general issues you describe - instability that shows up as memory / resource leaks - we have seem similar symptoms. We have not had much luck getting them down to easily reproducible situations. Like you, it often hits us after 24 hours (or even 6 or 8 days).
If it's just the client then rewriting the odbc client lib from the ground up is starting to sound like less trouble than debugging the current driver.
I'd even settle for a driver that only works locally as that's what I use, I wonder how hard it would be to write one...
Hmm, this sounds very much like the problems I started seeing when changing from ':ZDB' to '127.0.0.1:ZDB', performance was halfed by that as well, so I suspect that the latter DSN was causing the driver to go through the network to get to localhost (well, I guess it would have to), stability went way down and it ended up hanging the x_server process so that I had to restart it to be able to connect again.I will note that the big thing we did was shifted from "same server" (ServerNode= not present on connection) config to two separate machines... and the quality of our SAPDB experience dropped like a rock.
My theory is that the code that handles connections over the network is as reliable as a demented rat on crack and that the odbc driver isn't much better.
My guess is that SAP doesn't use ODBC internally (mumblelivecachemumble) and therefore don't really care about it working, which is fair enough in a way, it just means that the people that do care about using ODBC have to pick up the slack.
Any takers?
--
Regards Flemming Frandsen - http://dion.swamp.dk
PartyTicket.Net co founder & Yet Another Perl Hacker
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
