Enhance Site Performance

Ukončen Zveřejněno Mar 15, 2016 K zaplacení v momentě doručení
Ukončen K zaplacení v momentě doručení

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 Zpracování dat MySQL PHP

Identifikační číslo projektu: #9956067

O projektu

25 nabídek Projekt na dálku Aktivní Apr 22, 2016

25 Freelnceři na tento projekt zveřejňují nabídky v průměru $558

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 Další

$721 USD za 10 dní
(170 Recenzí)
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 Další

$515 USD za 10 dní
(166 Recenzí)
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 Další

$773 USD za 20 dní
(26 Recenzí)
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 Další

$500 USD za 5 dní
(26 Recenzí)
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 Další

$250 USD za 3 dní
(20 Recenzí)
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 Další

$478 USD za 9 dní
(5 Recenzí)
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. Další

$555 USD za 10 dní
(4 Recenzí)
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 za 10 dní
(2 Recenzí)
2.3
sengsourng

A proposal has not yet been provided

$333 USD za 25 dní
(0 Recenzí)
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 Další

$250 USD za 5 dní
(0 Recenzí)
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 Další

$500 USD za 10 dní
(0 Recenzí)
0.0
mannykk

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

$750 USD za 30 dní
(0 Recenzí)
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 Další

$555 USD za 10 dní
(0 Recenzí)
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 Další

$555 USD za 10 dní
(0 Recenzí)
0.0