OpenEuphoria

Re: ODBC.ew

• Posted by Michael J. Sabal <m_sabal at yahoo.??m> Oct 12, 2007
• 740 views

Matt Lewis wrote:
> 
> Michael J. Sabal wrote:
> > 
> > I've
> > elected to change my methodology to execDirectODBC; although I won't be able
> > to test it until later this afternoon.
> > 
> Try switching to freeHandleODBC() and see
> if the memory usage is better.
> 
> Matt

I haven't had a chance to try adding freeHandleODBC() to my original code,
but switching to execDirectODBC() has resulted in about 75% less code,
faster execution, and overall stable memory usage of 9MB.  I'm sure there
are valid reasons for using prepareSQL; but with a high-end database server,
I would have to recommend using execDirectODBC for all queries.