Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > Database and Reporting > Memory Ussage


Reply
 
Thread Tools Display Modes
  #1  
Old 01-20-2003, 07:40 AM
LMPhoenix LMPhoenix is offline
Freshman
 
Join Date: May 2002
Posts: 35
Default Memory Ussage


Hi i use a mysql class file to connect to a mysql database
now over time this program makes several queries
But ive noticed the app takes up more and more memory

Ive tried closing the connection and setting the mysql= nothing then reconnecting before each query but it still does the same
could it be the adoc thats using the memory ?????

any help will be gratefully apreciated as a lot of my apps r gonna need mysql connections
Reply With Quote
  #2  
Old 01-20-2003, 10:29 AM
Thinker Thinker is offline
Iron-Fisted Programmer

Retired Moderator
* Guru *
 
Join Date: Jul 2001
Location: Fayetteville Arkansas USA
Posts: 18,127
Default

We would need a lot more details to even guess. Chances are,
you are creating more and more connection/recordset objects
without properly releasing them. But there is no telling right now.
__________________
Posting Guidelines
Reply With Quote
  #3  
Old 01-22-2003, 07:29 AM
LMPhoenix LMPhoenix is offline
Freshman
 
Join Date: May 2002
Posts: 35
Default

Ive included a copy of the class file and the wrapper im using
is this anymore useful ???
Attached Files
File Type: zip mysql.zip (201.1 KB, 3 views)
Reply With Quote
  #4  
Old 01-29-2003, 03:18 AM
LMPhoenix LMPhoenix is offline
Freshman
 
Join Date: May 2002
Posts: 35
Default

****Bump****
Reply With Quote
  #5  
Old 01-29-2003, 08:23 AM
Thinker Thinker is offline
Iron-Fisted Programmer

Retired Moderator
* Guru *
 
Join Date: Jul 2001
Location: Fayetteville Arkansas USA
Posts: 18,127
Default

This is all API, there is no ActiveX data access going on. No way
in the world we could tell what is going on in that DLL, or tell how
VB is dealing with process memory. So much pointer manipulation
happening with copymemory that you either have to understand
the whole thing, or just take it by faith.
__________________
Posting Guidelines
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
 
 
-->