Rails - Sep 2007 - RoR on windows with MS SQL Server DBI:ADO driver Memory Leak

i''m running ruby 1.8.5 and rails 1.2.3 on windows with a bunch of
mongrels that are proxybalanced via apache 2.2.4

the db adapter i''m using is the sqlserver one in ADO mode. so
it''s using
win32ole.

when a mongrel service is freshly started it consumes about 40 megs of
ram. but about each and every request is leaking memory. about 20 megs
per hour(!!!).

so after half a day the mongrel processes are at 300 meg each and the
server barely responds at all.

at first i thought i have a bad memory leak in my app code but when i
switch the mode to odbc they will stay very stable at 40-41 megs without
any noticable changes.

the problem is i''m accessing a legacy database with tables still in use
by an IIS driven classic asp webapp that has data in windows-1252
encoding while the rails app itself is completely using UTF-8 for it''s
newer own tables. and to properly read the legacy table data i set

WIN32OLE.codepage = WIN32OLE::CP_UTF8

which enabled me to read the old tables properly.

with the odbc driver this doesn''t work because it''s not using
win32ole.

is there any way to fix that memory leak without switching to odbc and
manually Iconv''erting all data from the old tables?
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---