Buying Urgent needed Db Expert

Discussion in 'Programming' started by rajivv, Oct 27, 2010.

0
  1. #1
    Hi

    Our site is being optimized right now cause the DB/sql is messed up
    The developers of the site are no longer available hence had to give
    the DB/sql opti. and on page opti to another vendor.

    Now the work is almost complete but db is still suffering there are queries taking lose to 3-7 seconds the vendor is also lost as he has done all the work but not seeing performance.

    Also while opti db he was not able to normalize db as not possible to explain DB as no documentation

    Need someone to rectify urgent ..
    Quickly and cheaply , experts only please
     
    rajivv, Oct 27, 2010 IP
  2. hirensoni913

    hirensoni913 Peon

    Messages:
    79
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    SQL means MySql or MSSql ?? Anyway please check your pm
     
    hirensoni913, Oct 28, 2010 IP
  3. gordi555

    gordi555 Active Member

    Messages:
    537
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    58
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #3
    Please send me a sample SQL query and I'll see what I can do for you!
     
    gordi555, Oct 28, 2010 IP
  4. Girithara Prakash

    Girithara Prakash Member

    Messages:
    34
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #4
    Hi,
    You need to add index to index, performance will be improved 200%. please pm me,i can help.
     
    Girithara Prakash, Nov 9, 2010 IP