Re: C# application slow to response after period of inactivity - C# Discussion Boards

Re: Virtual methods and reduntant XmlDoc

dojohansen31-Oct-09 2:31

dojohansen

31-Oct-09 2:31

Brilliant, thanks a lot!

C# application slow to response after period of inactivity

RobScripta30-Oct-09 3:48

RobScripta

30-Oct-09 3:48

I have a windows forms application made with C# Express edition 2008, connected with a MySQL database on internet.

The application in this combination is usualy lightning fast, but after a certain period of inactivity (say 30 minutes) the application takes forever (say 60 seconds) for it's first response. After the first response the application is snappy again.
As most of the times the application is used in response to a customer request (either by phone or in person) it's very annoying looking at each other for 60 before continuation.

The probable causes are:
- usualy the connections to the database are reused, which means they don't have to be created every time a database connection is needed. The theory is that after a certain amount of time the connection is destroyed anyway.

Question:
Is this a plausible explanation, and if so how can I keep the connection with the database (I open the connection for every request, and close it immediately after completion so I don't intend to keep the connection open, but just keep the connection).

Somebody else told me it could be Windows swapping the application to virtual memory (== harddisk) after inactivity.

Question:
Is this a probable explanation, and if so how can I test this theorie, and again what can I do to prevent this behaviour ?

Thanks for any hints and tips

Rob

Re: C# application slow to response after period of inactivity

Saksida Bojan30-Oct-09 4:45

Saksida Bojan

30-Oct-09 4:45

PosiRob wrote:
The application in this combination is usualy lightning fast, but after a certain period of inactivity (say 30 minutes) the application takes forever (say 60 seconds) for it's first response

60 seconds it way to much for database connection problem. What OS are you using? I Know that Vista and Win7 has properties in advanced power management for IDLE HDD. That option make HDD shut down if nothing was read or write on it after period of time. Before I Discovered this setting my HDD needed approximately 1 minute before I could start using it

Re: C# application slow to response after period of inactivity

RobScripta30-Oct-09 5:20

RobScripta

30-Oct-09 5:20

Thanks for this answer, my clients run mostly on XP, but it's not impossible that XP also has these "features".

I have XP/Vista and Windows 7 so I can investigate this theory, thanks for thinking

Rob

PS, I marked question by accident as solved. Other suggestions are still welcome.

Re: C# application slow to response after period of inactivity

Saksida Bojan30-Oct-09 5:40

Saksida Bojan

30-Oct-09 5:40

Hello. I Just checked about that options, and it exists in WinXP. Under Screen saver tab, there are settings for power options.

I do remember this on Vista, because it was set to default to 15 minutes. And i have about 4 internal HDDs. And every time I attempted to access HDD after 2 hours of inactivity I got a very big system LAG due to HDD powering on. However I don't remember it affected HDD with OS installed on it

Re: C# application slow to response after period of inactivity

Paulo Zemek30-Oct-09 7:21

Paulo Zemek

30-Oct-09 7:21

The swap can be a problem. Try disabling virtual memory to see if this behavior changes.

The connection to the database being lost could also be a problem. You may want to execute some "keep-alive" command from 30 to 30 seconds to see if this stops happening.

Also, the HD being power off can be a problem. But, have you noticed this in other applications running in that computer?

Re: C# application slow to response after period of inactivity

RobScripta30-Oct-09 21:40

RobScripta

30-Oct-09 21:40

Thanks for the suggestions. The client computers usually only run my application so I can't say if other applications face the same problem.

Excuse my ignorance, but do you have an example of a keep alive command ?

Thanks for your time.

Rob

Re: C# application slow to response after period of inactivity

dojohansen31-Oct-09 22:40

dojohansen

31-Oct-09 22:40

PosiRob wrote:
do you have an example of a keep alive command ?

Yes: SELECT 1

I think what he means by a "keep-alive command" is simply *any* command executed for the purpose of keeping the connection alive, not a special command.

Be aware that if you are using connection pooling, calling Close() does not actually close the connection to the database (it simply returns the connection to the pool). A whole minute to re-establish the connection sounds like a lot, but then I don't know anything about your environment or how you connect to the database.

Re: C# application slow to response after period of inactivity

Paulo Zemek1-Nov-09 2:57

Paulo Zemek

1-Nov-09 2:57

Exactly. The keep alive command is only a command to be executed, that will not cause any data changes and is fast. It will only force the connection to be used.

How to show "Press any key to Continue"

yakupc30-Oct-09 3:41

yakupc

30-Oct-09 3:41

Hi,
Is there any way to show "Press any key to Continue" message end of the run VS Console application.

Re: How to show "Press any key to Continue"

Richard MacCutchan30-Oct-09 3:55

Richard MacCutchan

30-Oct-09 3:55

yakupc wrote:
Is there any way to show "Press any key to Continue" message end of the run VS Console application

Within Visual Studio if you start debugging with Ctrl-F5 it will do it automatically.

When you run your program outside this environment you will need to code it yourself (Console.Write and Read).

Re: How to show "Press any key to Continue"

vtchris-peterson30-Oct-09 4:14

vtchris-peterson

30-Oct-09 4:14

By default, "Ctrl+F5" is mapped to "Start Without Debugging"

Re: How to show "Press any key to Continue"

yakupc30-Oct-09 4:18

yakupc

30-Oct-09 4:18

worked.It is great.Thank you so much.

Re: How to show "Press any key to Continue"

Luc Pattyn30-Oct-09 3:56

Luc Pattyn

30-Oct-09 3:56

Console.WriteLine("Press any key to Continue");
Console.ReadKey();

the second statement is optional. Laugh | :laugh:

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Re: How to show "Press any key to Continue"

dojohansen31-Oct-09 22:42

dojohansen

31-Oct-09 22:42

And a less user-friendly variant:

while (true) 
{
  Console.WriteLine("Continue to press any key.");
  Console.ReadKey();
}

Re: How to show "Press any key to Continue"

vtchris-peterson30-Oct-09 4:31

vtchris-peterson

30-Oct-09 4:31

Alternate implementation. I actually think the other solution is better, but I was curious if this would work (and it does). Note that UseShellExecute is important, otherwise the process is opened in a new window. The disadvantage is that you're more tightly coupled with the OS (i.e. it wouldn't work under Mono on a non MS-platform)

using System.Diagnostics;

   // ...

   ProcessStartInfo psi = new ProcessStartInfo("cmd", "/c pause");
   psi.UseShellExecute = false;         
   Process.Start(psi).WaitForExit();

Re: How to show "Press any key to Continue"

PIEBALDconsult30-Oct-09 4:40

PIEBALDconsult

30-Oct-09 4:40

Or run it from a BAT file.

myapp.exe
pause

Re: How to show "Press any key to Continue"

Luc Pattyn30-Oct-09 6:28

Luc Pattyn

30-Oct-09 6:28

@echo off Sniff | :^)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Re: How to show "Press any key to Continue"

PIEBALDconsult30-Oct-09 7:18

PIEBALDconsult

30-Oct-09 7:18

I didn't want to confuse the reader with such details.

SQLite

jashimu30-Oct-09 3:04

jashimu

30-Oct-09 3:04

Hi All, I am facing a problem when I try to insert into sqlite database.
sql_cmd.CommandText = "INSERT INTO test('name')VALUES ('Value2')";
it is giving me error saying test table does not exist but in reality it does.
can you please tell me what I am doing wrong.

thanks in advance.

Re: SQLite

Not Active30-Oct-09 3:20

Not Active

30-Oct-09 3:20

Have you asked or looked here[^]

I know the language. I've read a book. - _Madmatt

Message Closed

30-Oct-09 4:04

stancrm

30-Oct-09 4:04

Message Closed

modified 23-Nov-14 7:25am.

Re: SQLite

jashimu30-Oct-09 5:09

jashimu

30-Oct-09 5:09

Hi stancrm, I did try it but did not work. I try also other suggestion too. Nothing is working.
Thanks for you help. if you know anything else I will give a try.

thanks

Re: SQLite

Amit Patel198530-Oct-09 4:10

Amit Patel1985

30-Oct-09 4:10

Hi All,

Try to run this command in sql server u will come to know what is the problem.

Thanks,

Amit Patel

Re: SQLite

Eddy Vluggen30-Oct-09 5:53

Eddy Vluggen

30-Oct-09 5:53

I believe that column-names aren't enclosed in quotes;

sql_cmd.CommandText = "INSERT INTO test (name) VALUES ('Value2')";

I are Troll Suspicious | :suss:

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.