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.