Multiuser issue

Discussion in 'ASP .Net' started by Tangent, Nov 11, 2003.

  1. Tangent

    Tangent Guest

    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
    Tangent, Nov 11, 2003
    #1
    1. Advertising

  2. Tangent

    George Durzi Guest

    How are you contructing your SqlDataCommand?

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

    "Tangent" <> wrote in message
    news:b261a$3fb12a85$94400ff8$...
    > 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, Nov 11, 2003
    #2
    1. Advertising

  3. "Tangent" <> wrote in message
    news:b261a$3fb12a85$94400ff8$...
    > 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.


    --
    John
    John Saunders, Nov 11, 2003
    #3
  4. Tangent

    Tangent Guest

    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...


    George Durzi wrote:

    > How are you contructing your SqlDataCommand?
    >
    > You might want to look into using a prebuilt data access solution like
    > Microsoft.ApplicationBlocks.Data.
    >
    > "Tangent" <> wrote in message
    > news:b261a$3fb12a85$94400ff8$...
    >
    >>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
    >>

    >
    >
    >
    Tangent, Nov 11, 2003
    #4
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Bhavin Patel

    How to write multiuser application?

    Bhavin Patel, Jun 3, 2004, in forum: Perl
    Replies:
    1
    Views:
    734
    Jim Gibson
    Jun 3, 2004
  2. Manuel Arroba
    Replies:
    5
    Views:
    419
    John Saunders
    Jun 8, 2004
  3. Michael A. Covington

    Setting up Eclipse in a multiuser environment

    Michael A. Covington, Feb 5, 2004, in forum: Java
    Replies:
    1
    Views:
    1,321
    Neil Campbell
    Feb 5, 2004
  4. Robert
    Replies:
    7
    Views:
    2,914
    Will Hartung
    Sep 25, 2004
  5. Howie
    Replies:
    1
    Views:
    355
    Thomas Matthews
    Oct 24, 2003
Loading...

Share This Page