Hi all,
(
duplicated post from LAVA)
I developped a relatively small application in LV 7.1.1 that saves data every 5 sec to a DataBase (MSSQL) using SQL toolkit.
This
is the first time I use this toolkit and my knowlegde regarding
DataBase is really poor so I might just be doing a beginner's mistake.
Here is the issue :
If I
disable the "write to DataBase" functions
my application can run forever without any trouble an its memory usage
in thet task manager is 34120K and will not move of a byte.
If I
enable the "write to DataBase"
functions, the memory usage will slowly increase, then the system
starts using Virtual Memory, and after 15 days (approximately), the max
amount of virutal memory allowed is met, the PC crashes down and has to
be restarted.
Obviously I must be making a bad use of SQL VIs...
So, is there any "common silly mistake" to avoid when writing data to MSSQL DataBase ?
If needed I can upload my code...
Thanks for any help.
We have two ears and one mouth so that we can listen twice as much as we speak.
Epictetus
Antoine Chalons