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

ARon_30-Oct-09 6:43

30-Oct-09 6:43

Tao OpenGL framework or maybe XNA of Managed DirectX with native support for .x files could work but you will have to write the DirectX or OpenGl pluming. Still a lot work , but there is a lot of supporting documentation.

http://www.taoframework.com/[^]

http://creators.xna.com/en-US/[^]

ARon

How to deploy a c# application connected to sql server express database ?

Dr.DigiTaL30-Oct-09 5:58

Dr.DigiTaL

30-Oct-09 5:58

Hello every one,
I have sql server 2005 express edition installed and I created the database using it.I then developed a C# application that connects to this database. Now I want to deploy all of this to a client PC (only 1 client).
does he need to have SQL server installed ?
What steps should I do to deploy ?

Thanks

All You Need Is A Good Friend

Re: How to deploy a c# application connected to sql server express database ?

Not Active30-Oct-09 6:02

Not Active

30-Oct-09 6:02

Perhaps this[^] will help

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

Virtual methods and reduntant XmlDoc

dojohansen30-Oct-09 4:14

dojohansen

30-Oct-09 4:14

Hi,

I was wondering if anyone knows if there is a way of avoiding duplication of documentation when using virtual methods and polymorphy.

If we use virtual methods properly they are overridden to do something in a different way, not to do something else, in a logical sense. Hence, the doc for an override should be the same as for the method it overrides.

Is there any way to avoid having to copy the doc to all the base classes? Obviously the doc should be pretty stable in a perfect world, but then again the world is often imperfect and it's a pain to maintain consistency this way...

[edit]
Btw, I apologize if the C# forum isn't the approriate one for my question. XmlDoc is a C# feature, even if VB.NET and maybe other CLS-compliant languages provide something similar nowadays, so I didn't know where else it might go. Please say so if you feel there's another forum that would be more appropriate.
[/edit]

Re: Virtual methods and reduntant XmlDoc

Gideon Engelberth30-Oct-09 5:27

Gideon Engelberth

30-Oct-09 5:27

In situations like that, I typically use the include tag like so:

<include file="xmldoc_common.xml" path="//method[@class='BaseClassName' and name='VirtualMethodName']/*" />

and the file will look like:

<xmldoc>
    <method class="BaseClassName" name="VirtualMethodName">
        <summary>The method does such and so.</summary>
        <returns>A value depending on what happened</returns>
        <exception cref="ArgumentNullException"><paramref name="paramA" />
        is null.</exception>
    </method>
</xmldoc>

This lets you share as many or as few tags as you want. If you want to have separate remarks for each, just leave the remarks out of the common and put them on each derived class that needs them. If you need some common remarks and some class-specific remarks, well I haven't really worked that out. I think I tried it once and ended up with two remarks sections in the Sandcastle output.

Only the summary, returns, exception, etc must match what is in the normal XML comments, all other tag names are whatever you want.

The external xml file goes in the project (not solution) root.

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.

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