[REBOL] [SDK] [ODB] Memory leak? Frozen DB Calls?
From: ammon:addept:ws at: 27-Apr-2004 15:30
I have an SQL Server...
Quad P4 2Ghz
2GB RAM
I have two servers that run 4-6 programs that make calls to the SQL Server
every few minutes...
2.4 GHz P4
512 MB DDR RAM
I have a little reblet that makes several DB Calls (50-100) every hour on
the hour. Some of these calls get kinda large (~50k records each) If I run
the reblet every now and then closing it after it runs its process then
everything runs smoothly but if I leave it running on one of the servers
then a particular one of the DB programs freeze on that server. If I leave
it running on another machine then the program freezes on both servers. I
open a fresh DB connection and close it when it is done so it isn't leaving
a connection open but I don't UNSET any variables. Any ideas?
Thanks!!
~~Ammon ;~>