1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

I need a PHP Expert

Discussion in 'Hire a Freelancer' started by BassTrackerBoats, Nov 30, 2011.

  1. BassTrackerBoats

    BassTrackerBoats Moderator Staff Member Moderator Jr. VIP

    Joined:
    Mar 10, 2010
    Messages:
    12,741
    Likes Received:
    21,953
    Occupation:
    I don't actually have a job
    Location:
    It's an Algo, of course it can be gamed.
    Home Page:
    We are looking for someone who can performance tune our DB, as the DB
    grows our performance degrades.

    We need someone who can

    1- Analyze our schema for potential improvements - solutions for
    troublesome queries etc.
    2- Suggest hardware spec for our system and MySQL config optimizations
    3- Possibly implement clustering

    This is for a legit expert not for someone who thinks they can do it... I want a pro and am willing to to a fair rate to one that is a pro.

    Shoot me an email with your qualifications please - gregatbizop@gmail.com
     
  2. essares1

    essares1 Junior Member

    Joined:
    Apr 27, 2009
    Messages:
    163
    Likes Received:
    27
    Your thread title and your post requirement have no connection whatsoever ;). You will have better responses if you change your title to "I need a MYSQL DB expert". Just a thought :)
     
    • Thanks Thanks x 1
  3. cbnoob

    cbnoob Senior Member

    Joined:
    Sep 27, 2010
    Messages:
    967
    Likes Received:
    455
    PHP experts should have thorough understanding of MySQL
     
    • Thanks Thanks x 1
  4. BassTrackerBoats

    BassTrackerBoats Moderator Staff Member Moderator Jr. VIP

    Joined:
    Mar 10, 2010
    Messages:
    12,741
    Likes Received:
    21,953
    Occupation:
    I don't actually have a job
    Location:
    It's an Algo, of course it can be gamed.
    Home Page:
    Both of you guys know tons more than I do... my partner is the technician and asked me to post this... I am sure that I could have put a better title up but when we were talking I though he said PHP expert but then again I'm not even remotely technical.

    I appreciate the input from both of you so that others that read this will get a better understanding of what we need.
     
  5. hitman247

    hitman247 Executive VIP Premium Member

    Joined:
    Oct 12, 2008
    Messages:
    738
    Likes Received:
    1,851
    Occupation:
    Full Time IM
    Location:
    Your Six O'clock
    Home Page:
    • Thanks Thanks x 2
  6. essares1

    essares1 Junior Member

    Joined:
    Apr 27, 2009
    Messages:
    163
    Likes Received:
    27
    "understanding" doesn't cut it for him. He obviously needs a pro. He is not technical so he put up the wrong title. I know many PHP "experts" that don't have a clue of database optimization. And many DB experts are not PHP experts. If an actual mysql pro sees the thread title, he may pass it assuming he needed a PHP expert, which is why I suggested a more apt title may bring in more relevant views.

    Anyways good luck with your search BTB
     
    • Thanks Thanks x 1
  7. scraper1

    scraper1 Regular Member

    Joined:
    May 28, 2011
    Messages:
    214
    Likes Received:
    207
    Location:
    Kontiki
    Home Page:
    One solution would be to check out a non-relational database like CouchDB. It's fairly easy to deploy and use. One of my tasks at my former job was to move the current MS SQL DB to a CouchDB solution(even though my cup of tea is C#). With it you can simplify the SQL queries using lists and views and you can really improve the query execution time. Just a thought.
     
    • Thanks Thanks x 1
  8. eterxx

    eterxx Junior Member

    Joined:
    Mar 25, 2011
    Messages:
    119
    Likes Received:
    45
    Occupation:
    a little bit of this, a little bit of that
    Hi, I don't know how to optimize db queries, but if you to optimize the website and not only the db, I can analyze your website's performance and tell you what needs to be done.
    I can obtain up to 98/100 on page speed score for a simple website (of course it depends on its complexity).
    Just send a PM if you are interested :)
     
    • Thanks Thanks x 1
  9. BassTrackerBoats

    BassTrackerBoats Moderator Staff Member Moderator Jr. VIP

    Joined:
    Mar 10, 2010
    Messages:
    12,741
    Likes Received:
    21,953
    Occupation:
    I don't actually have a job
    Location:
    It's an Algo, of course it can be gamed.
    Home Page:
    In the above, I understood the word "solution", the rest was Latvian to me.

    My business partner handles the technical end and has a day job which is why we thought it best for me to post the request for help.

    I do appreciate the input and will pass the above to him.
     
  10. Getwhatchuwant

    Getwhatchuwant Jr. VIP Jr. VIP Premium Member

    Joined:
    Jul 25, 2011
    Messages:
    1,922
    Likes Received:
    1,302
    Occupation:
    Peeping Tom
    Location:
    Florida
    BTB My brother in law is a Database guy, PM me a phone # and I will forward him the info and see if he can help!!
     
    • Thanks Thanks x 1
  11. Scripteen

    Scripteen Elite Member

    Joined:
    Sep 19, 2009
    Messages:
    1,811
    Likes Received:
    1,918
    Home Page:
    You can just contact me and I will look into it.
     
  12. goinviral

    goinviral BANNED BANNED

    Joined:
    Jun 3, 2011
    Messages:
    408
    Likes Received:
    193
    Greg, I had similar problems with my mysql databases for the phone stuff and there are 2 things you basically have to remember with mysql

    1) on a live production table set no indexes!!! All reports should be run on a copy of the production database.

    2) make the primary key autogenerated and not some number you plugin.

    Let Kevin know he should understand what I am saying. Mysql is fast but can be finicky. Also tell him to remove any spoorious columns. on your main working tables only collect essential data.
     
    Last edited: Nov 30, 2011
  13. xpwizard

    xpwizard Junior Member

    Joined:
    Nov 6, 2010
    Messages:
    198
    Likes Received:
    122
    Yeah I would recommend non-relational database, although I would use MongoDB instead of CouchDB.

    (Craigslist, sourceforge, bit.ly and a lot of others all use Mongo ;)).

    Also, in regards to MYSQL, go to the page below and try running the "MySQL Performance Tuning Primer Script" script. It's a basic optimizer but it will alert you if you should change any settings.
    (Make sure the server has been running for a while before running the script).

    Code:
    http://www.day32.com/MySQL/
     
  14. goinviral

    goinviral BANNED BANNED

    Joined:
    Jun 3, 2011
    Messages:
    408
    Likes Received:
    193
    non relational databases are good depending on what you want to do. I am pretty sure wordpress can't use them yet and if you dont know how to use them then there is a bit of a learning curve and also be preapred to have some HUGE tables
     
    • Thanks Thanks x 1