Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

[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 ;~>