Results 1 to 3 of 3

Thread: Need 4 Speed

  1. #1
    Join Date
    Dec 2005
    Posts
    14

    Unanswered: Need 4 Speed

    Hi all,

    Trying to strip down and optimize a MYSQL proccess. Written in VBStudio classic using simple enough SQL a couple of joins etc.
    Looking to speed up this process as much as poss, have looked at indexes and used EXPLAIN to check them, and incresed the table_cache and max_connections etc. which helped but not enough.

    If ne one has ne ideas or a link to a good resource for MYSQL optimization it would be much appriciated.

    + if ne one has links to a good vb resource aimed specificly at good SQL programming practices and optimization.

    Cheers

  2. #2
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    I think your keyboard is broken.

  3. #3
    Join Date
    Dec 2005
    Posts
    14
    Thnx real helpful

Posting Permissions

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