Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Posts
    1

    Unanswered: Why my application got slow when operates over the network?

    Hi Guys,

    I have a problem regarding with my application.My application was developed in visual basic 6.0 and my back-end is MySQL.My problem was the fetching of data initially are very slow when operates over the network,but when I operates locally the speed was acceptable.Here the set-up, 3 client are using an application simultaneously and connected thru myodbc-2.50.39-nt to the server with an OS(Windows Server 2003).The application exe and database are mapped.Is there a problem with my setting?How can I implement the handshaking?

    I hopefully sombedody help me and thanks in advance

    Thank you,
    Joy

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    by locally.. do you mean connecting to a server on the same development machine? that will always be dramatically faster.

    it sounds like you have either a design problem, or a server tuning problem, or possibly users with overly demanding requirements (and possibly a bit of all 3).

    sounds dumb, but are you retrieving only the data the user requires (so there is no redudnant data pumped up and down the line), are you taking maximum advantage of the server to do its processing

    have you checked the server loading.. does it need more memory, can you identify if there are queries which are clogging the server.. it may be reviewing the indexing strategy may help. forget if its show or explain on MySQL.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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