Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    660

    Unanswered: run database slower

    I have database, Visual basic as front end, and sql server as backend, the reports are using crystal report. Recently, the user complain it is too slow to run, it took a long to load the data, anybody help me? Thanks in advance.

  2. #2
    Join Date
    Mar 2004
    Posts
    660
    How can i check what cause this problem. I check the active log file, it didn't help.

  3. #3
    Join Date
    Oct 2003
    Posts
    60
    You have to look a couple of things:
    1. Design of the database
    2. Indexes
    3. Execution plan of your queries.

    Without this info, it is very hard to provide any help.
    jaraba

  4. #4
    Join Date
    Mar 2004
    Posts
    660
    It is sometime very slow. I will check these you posted as this system was design by somebody else. I had question, can this sql server perfome slower in some case that is not relation to design that you said? I want to make sure it is not sql server problem. So i will only check the design. Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •