05-22-2007 06:00 AM
05-22-2007 06:40 AM
05-22-2007 08:43 AM
My program is allways in a monitoring loop, and refresh the screen with some database parameters (Oracle Database with ODBC driver), my first approach is close the connections in the end of each loop, but this is a problem because the open connection takes too much time and isn't suitable for the loop time, after that i remove the close connection, and it works "fine". "Fine" because when the application is running for some hours (or days) the application comes too slow (e.g. i press a button and the response takes 1 minute), and some times gives a database connection error.
My suspect is that this is related with the ODBC connection (driver) and the way as Labview manages them (open/close/retain connection/memory).
Do you have any suggestions about this, or how can i find what is the problem?
05-25-2007 02:32 AM
Richard Keromen
05-25-2007 03:26 AM
05-29-2007 09:39 AM - edited 05-29-2007 09:39 AM
Message Edité par Richard K. le 05-29-2007 09:40 AM
Richard Keromen
05-29-2007 09:50 AM
Isn' t proprely a Vi, but yes an application with a lot of vi /sub -vi's. (The project has around 90 files)
Because that isn't easy to detect the problem....
...and because this needs the database, isn't possible to run without the database and its structure configured.
06-03-2007 12:40 AM
06-11-2007 03:47 AM
Mike,
This isn't a problem because i'm almost only doing queries to the database, and is all in stored procedures at the databases side. (for speed performance).