Enhance Site Performance

Closed Posted Mar 15, 2016 Paid on delivery
Closed Paid on delivery

Hi Guys,

Need some help with the SQL restructure for my site, this is the test site, we found that the sites loads extremely slow when we try to put in a amount of around 10 K users and other db. Need someone to check and advice us and help on improving the db structure so that it won't have a performance issues even it holds 10 - 20 Millions data. Thanks.

Please approach me to get the test site URL and details.

Below are the code & db specification that we are using currently.

Database Server

Server: Localhost via UNIX socket

Server type: MySQL

Server version: 5.6.29-log - MySQL Community Server (GPL)

Protocol version: 10

Server charset: UTF-8 Unicode (utf8)

Web Server

cpsrvd [login to view URL]

Database client version: libmysql - 5.1.73

PHP extension: mysqli Documentation

phpMy Admin

Version information: 4.0.10.7, latest stable version: 4.5.5.1

Documentation

Wiki

Official Homepage

Contribute

Get support

List of changes

Cassandra Data Processing MySQL PHP

Project ID: #9956067

About the project

25 proposals Remote project Active 7 years ago

25 freelancers are bidding on average $558 for this job

meet2amitvw

Let's discuss more about project to finalize the proper scope with estimated cost and time so ping me over the freelancer chat. I am myself developer so you will directly work with me. No mediators. No managers. No More

$721 USD in 10 days
(170 Reviews)
9.3
pr0digysl

Bonjour I'm Dario, an experienced Database Administrator and Developer located in Naples, Italy. I reviewed your bid request and I'm interested in it, as I'm experienced in database and server optmization and tunin More

$515 USD in 10 days
(166 Reviews)
6.8
Shopify

I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably More

$773 USD in 20 days
(26 Reviews)
6.9
milliard

Hello, Understanding: - We have to enhance your site performance - Need to restructure your SQL queries (if needed) - Site is very high with around 10 K users - We can check and improve db structure We ca More

$500 USD in 5 days
(26 Reviews)
6.0
kienngd

Dear sir, please contact me, we will discuss about your requirements. As I understand you need to increase performance of your current system with very large data. With this type of project, I suggest we will setup a t More

$250 USD in 3 days
(20 Reviews)
4.6
Gmcconsulting1

Dear Sir, With reference to your post regarding SQL data base structure improvement ,I am glad to inform you that we can easily restructure the database of your site, so as that it loads quickly even after the data of More

$478 USD in 9 days
(5 Reviews)
3.9
PixelITmanagemen

Hello dear. You can see That i have no many projects done yet. I will be so glad if Your project will be another . Working on PHP MYSQL HTML CSS HTML5 CSS3 JAVA SCRIPT JQUERY BOOTSTRA. Wordpress IS my HEART. More

$555 USD in 10 days
(4 Reviews)
2.1
hasanucak

hi. i worked on big data via oracle , mysql db that 60G data load per day. my last project on php,mysql,little cassandra on centos linux. it has 100k users and more hundred linux server. i can do your job.

$444 USD in 10 days
(2 Reviews)
2.3
sengsourng

A proposal has not yet been provided

$333 USD in 25 days
(0 Reviews)
0.0
boesvw

there are several things that may affect your database performance: 1. database structure 2. how your application access the database, this will determine how you should index some tables. in some cases you will have More

$250 USD in 5 days
(0 Reviews)
0.0
kresimirkos

I've optimized database with hundreds of gigabytes and million records of data, worked for several mid-large financial institutions with hundreds of live users, assisted programming teams to optimize their usage of the More

$500 USD in 10 days
(0 Reviews)
0.0
mannykk

im a professional db architect. expert in performance tuning. pay only u satisfy. quality guaranteed.

$750 USD in 30 days
(0 Reviews)
0.0
cmadsen

To increase the speed of loads, some solutions are dropping indexes, the amount of dta you are trying to load in a single record. These are just some examples of solutions. For a more detailed analysis I need to look a More

$555 USD in 10 days
(0 Reviews)
0.0
josephherbert

My role as CTO of 99Squared includes stress testing our scalable systems to handle millions of impressions an hour. I can advise you on system architecture, database design and PHP code efficiency. There are probably a More

$555 USD in 10 days
(0 Reviews)
0.0