Multiuser issue

[Tangent]

I have an application I developed that runs a number of stored SQL
procedures to provide the user with a set of information specific to
their user ID. The application runs well if only one person is on it.
If there is more than one person, the application slows to a crawl and a
number of errors occur.

Does anyone have an idea of what might be going on? I can provide more
info if needed.

Thanks,

Derek

 

[George Durzi]

How are you contructing your SqlDataCommand?

You might want to look into using a prebuilt data access solution like
Microsoft.ApplicationBlocks.Data.

 

[John Saunders]

I have an application I developed that runs a number of stored SQL
procedures to provide the user with a set of information specific to
their user ID. The application runs well if only one person is on it.
If there is more than one person, the application slows to a crawl and a
number of errors occur.

Does anyone have an idea of what might be going on? I can provide more
info if needed.

I think something is wrong.

 

[Tangent]

I rely heavily of SQLHelper Class in this application. The company
hosting the site is now saying that my ap is hogging too much server
resources for more than one person to on. They mentioned moving to
client variables to reduce server processes, but they weren't much help
beyond that...