Find Jobs
Hire Freelancers

Speed up mySQL database table with 11,000,000 rows

$30-250 USD

完了済み
投稿日: 9年以上前

$30-250 USD

完了時にお支払い
No php knowledge needed. There is a table of 11,000,000 which has been slowed down for no reason (result given in 20 to 100 seconds). The table was working fine when I had 10,000 row. When I added the 11,000,000 all the crashing came. The table is indexed, you need to find a way to speed it up. Fast work & reply is needed. If you're slow don't bid.
プロジェクト ID: 6985317

プロジェクトについて

12個の提案
リモートプロジェクト
アクティブ 9年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
Hello As far as I can tell, the indexes in your table are not properly done or used. I need to identify the queries that are performed against that table, to possibly also change a bit the code and to optimize the indexes and their use so that it performs faster. I might also need to fine tune the mysql service on your server, if you have a dedicated server with root access. Regards, Dragos
$133 USD 1日以内
4.7 (76 レビュー)
5.8
5.8
この仕事に12人のフリーランサーが、平均$125 USDで入札しています
ユーザーアバター
A proposal has not yet been provided
$222 USD 3日以内
5.0 (303 レビュー)
6.9
6.9
ユーザーアバター
Hi! My name is Eugene. I'm mysql expert. I can handle your request. If you are interested please contact me and we will discuss details. Thank you.
$155 USD 3日以内
5.0 (10 レビュー)
5.0
5.0
ユーザーアバター
I am Database developer, have years of experience working with MySQL/ SQL and oracle. I can provide you a quality database in less time. Lets discuss.
$140 USD 3日以内
4.9 (7 レビュー)
3.7
3.7
ユーザーアバター
Just create an index on field on which you are selecting your records. Please reply for more discussion. Thanks
$30 USD 3日以内
4.9 (10 レビュー)
3.4
3.4
ユーザーアバター
A proposal has not yet been provided
$155 USD 3日以内
5.0 (6 レビュー)
2.9
2.9
ユーザーアバター
6+ years experience in Linux Server Administration, extensive experience in installing, configuring: APF or CSF Firewall Apache & MySQL optimization MySQL optimization Database issues, backup and repair DNS configuration issues Load balancing PHP configuration, upgrades, and site errors Security lock down Disaster recovery Seamless Server migrations Proactive Server Monitoring Guaranteed Uptime Installing and configure new servers Firewall Installation and configuration Security Audit and Server Hardening Securing and Upgrading of SSH Server Installation of third party software and scripts LightSpeed and nginx Installation & configuration Kernel updates Exim tweaks – spam source detection and prevention Malware removal Plugin installation and configuration Backup configuration using either the internal control panel features, custom backup, rsync, or service such as R1Soft Failing services Disk space issues Fffmpeg and video Ttools And much more.
$111 USD 3日以内
5.0 (3 レビュー)
2.4
2.4
ユーザーアバター
Hi georgechalhoub, We have 20+ skilled mobile apps & Web development team, so please give few minutes for technical discussion of your requirement. Dedicated resource with full time availability to your project with Skype & email reporting with prompt response. Waiting for your reply & chance for further discussion.
$147 USD 3日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hi, you have wrong query which maybe is doing to many joins. Can you give more detaials about query you are executing and some table schema? Best regards, Michal
$55 USD 2日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hi, I am having 15 years of experience in the field on Software development. I am associated with Emilia Technologies. I am having strong command on MYSQL and can handle the complex problems related to database. We have created many desktop and web based application along with there database and got the excellent response from the client. We are comfortable in solving your issues. Looking forward to hear from you. Thanks and Regards Emilia team
$210 USD 3日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

LEBANONのフラグ
Hadath, Lebanon
5.0
52
お支払い方法確認済み
メンバー登録日:3月 16, 2014

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。