loop problems/memory problem

[ewankosayo]

I have a BIG Problem, I need to create a program that will loop 24x7 to check the database and it wouldn’t consume a lot of memory. My platform is vb6 or .net Any advise Please..

[cugone]

You could have a timer that checks the database every hour or so for new records instead of having it run constantly. (1 hour is 3,600,000 milliseconds if you need to know. :P )

[Killer42]

I have a BIG Problem, I need to create a program that will loop 24x7 to check the database and it wouldn’t consume a lot of memory. My platform is vb6 or .net Any advise Please..

What's the problem, exactly? This sounds pretty simple to create. I'd probably recommend going with a Timer control, as the prior message suggested.

Why should it use a lot of memory? If your table contains a huge number of records, and you keep a recordset open, this may be the case. But you only need to open a connection to the database, and then run SQL queries through that. This takes much less RAM.

[ewankosayo]

but I need to check my database every single second.

[ewankosayo]

why does the anti virus doesn't consume lot of memory even its active?

[ewankosayo]

that's what i wanted to do. the looping is active but it doesn't consume a lot of memory.

[hariharanmca]

but I need to check my database every single second.

Can you explain why you want to cehck every second?

[ewankosayo]

because of process flag. it's active and i need to check it..

[QVeen72]

Hi,

What backend db are you using, and what do you need to check in the table?
If using Oracle/SQL Server/MySQL then, write trigger for each table for : "Insert".
Checking from Frontend, each table may consume lots of resources, Triggers will not consume much. Do the checking inside the trigger itself..

REgards
Veena

[ewankosayo]

i'm using visual fox pro 6.0 free table.

[QVeen72]

Hi,

BTW, What checking do you need to do for each table/record?

Regards
Veena

[ewankosayo]

for example every time that my process flag was changed into 2 then i need to change it to 3. i can't afford to lose a second because were in a fast phase processing.

[hariharanmca]

for example every time that my process flag was changed into 2 then i need to change it to 3. i can't afford to lose a second because were in a fast phase processing.

You know wnereever you are changing the process flag there you make an update process. Why you are doing each and every second. That will slowdown your process.

[QVeen72]

Hi,

Where is the Process Flag..?
A Field in one table or in Many Tables..?

REgards
Veena

[ewankosayo]

i'm not the one who's changing the data of my processflag its the other system that i created.

[ewankosayo]

processflag came in a one table..

[QVeen72]

Hi,

Somehow, still not very convinced on what you are wanting to do.
Can you give the table structure for which you need to check? And what table/field you need to change/update?
Is the change always linear? Like if it changes to 2, you want to make it 3 (as you said in your earlier post)? 3 to 4 and so on. Or is there some other logic for that?
Explain the problem in detail..

Regards
Veena

[hariharanmca]

I know your system is an multi user system.
No problem, There also you are the one updating the flag (Look, the flag will not update itself! you have to update, like flage=1 etc..,)
So whereever you are giving flag= somthing there you have to do your process.

[ewankosayo]

yes its a multi user system.

[ewankosayo]

Is the change always linear? No.

I need to check and change the field processflag, for example the processflag is number 2 then I’ll change it to number 3 for the last update. The problem is the memory every time I use a loop it will consume a memory my system will runs 24hours a day.

[hariharanmca]

Can you post what you had tried.

[Killer42]

This thread is sure stretching out longer than I expected.

You should be able to just...

• Create an ADO connection to your database.
• Set up a timer to fire every second (or perhaps every half-second).
• When it fires, do your database logic.

What's the problem?

[ewankosayo]

it wont consume a lot of memory when i do that. because my system will runs 24hours a day...

[cugone]

it wont consume a lot of memory when i do that. because my system will runs 24hours a day...

Set it up as a Windows Service and it will run in the background.

[Killer42]

it wont consume a lot of memory when i do that. because my system will runs 24hours a day...

I'd say your best bet is to give it a shot, and see what happens. The term "a lot of memory" could mean anything. A few years ago, I had a machine which was fantastic, because it had a whole 4MB of RAM. Was that "a lot"? It sure was, at the time.

So how much is "a lot" for your situation? Like I said, give it a go and see.

I recently had an application which used about 1.2GB of RAM by opening some big ADO recordsets. When I got rid of the recordsets and started just running commands through the ADO connection, it reduced by something between 700 and 900MB. (The fact that it still uses hundreds of MB is unrelated - it has some enormous arrays).