Closed

optimize database for fast loading

the site has a hang time. i need the site to load faster

all signs lead the the detabase. it seems to have duplicate content.

I checked your website and it seems that the delay comes from your Magento application.

I noticed that your database is approximately 2GB in size. Below are listed largest tables:

Code:

=== Top 5 Largest Tables in rackdr91_new ========

Table name Size

-------------------------------------- --------

catalogsearch_fulltext_scope4 132.1 MB

catalogsearch_fulltext_scope2 132.1 MB

catalogsearch_fulltext_scope3 132.1 MB

catalogsearch_fulltext_scope1 120.4 MB

catalog_category_product 104.5 MB

Skills: eCommerce, Linux, Magento, MySQL, PHP

See more: website speed test, why is my website slow, wordpress speed optimization service, how to speed up database queries, wordpress site speed optimization plugin, how to improve website loading speed, website speed optimization, how to optimize wordpress website speed, tree view sql database tables code, fast loading flash site, ikariam database site code, fast loading template, fast loading flash, fast loading joomla, fast loading real estate listings aspnet

About the Employer:
( 122 reviews ) miami, United States

Project ID: #16713812

20 freelancers are bidding on average $185 for this job

A2Design

Hi, We're a full-cycle team of PHP developers. Our recent Magento projects: [login to view URL] [login to view URL] Ongoing development and bug fixing for Magento sites developed by other tea More

$350 USD in 3 days
(113 Reviews)
8.6
sapotacorp

Dear anonimous1872! I am ready to get started right away.... Can we discuss the project details. Our Magento's projects: [login to view URL] Our latest United States's projects: [login to view URL] More

$224 USD in 6 days
(920 Reviews)
8.5
extreamcode

HI There, I can assist you with optimize database for fast loading. I am very passionate about quality of my work, You will be pleased working with me. Let's have a quick chat to discuss it further. You can check More

$155 USD in 3 days
(86 Reviews)
7.6
surabhirathi21

We are expert in speed and load time optimization and can bring your google PageSpeed score to A ranking .Kindly share the website URL so that i am review it. We're a Pvt. Ltd. company based in New Delhi, India More

$200 USD in 7 days
(263 Reviews)
8.1
Friends4it

Ready to optimize your Website and Database to make it load faster and smoother. We have been working on several similar projects as well as providing long term maintenance services., Ready to start immediately.

$150 USD in 1 day
(276 Reviews)
7.6
vili1977

Hello. I woud like to help you with mysql optimization. I have expeience. Please read my feedbaks. Thank you.

$100 USD in 1 day
(522 Reviews)
6.9
zyeloncomputech

Hi sir, Thank you for giving opportunity for biding... we have gone through your requirements and we can improved your magento site speed according to your exact requirements. Please Before Awarding this proje More

$166 USD in 3 days
(200 Reviews)
7.0
sstechwebindia

hello there greetings....!! I have a team of experience developers and a long list of satisfied clients...offering you very cheap rate with sure result...so please give us a chance to start our business relation. More

$150 USD in 7 days
(189 Reviews)
6.9
ahsanaimersl

Hello Sir, I,m a Magento Developer and would like to do your work. I have done many projects in magento, Please see my profile. I will do your work in efficient and desirable way. Thanks

$200 USD in 3 days
(137 Reviews)
6.4
mizanbdit

Hi, I will remove unnecessary queries from the listed tables and make the site faster. I will enable cache and optimize scripts, images to speed up the site. Do you use vps? what is the capacity of the server/ I More

$211 USD in 4 days
(90 Reviews)
6.2
shreetec14

Hello I had 11+ years of expereience in web design and development and i am sure that i can do whatever custom works on webstore. Kindly view some of my own designed / developed Magento stores here that can esta More

$100 USD in 2 days
(51 Reviews)
5.6
BeTheBestOnline

Hello, I am very interested to be part of your project. Currently, I’m a full-time freelancer with a background in Magento 1.x and 2.x. So I can definitely meet the job expectations. I can start work for you as s More

$200 USD in 4 days
(61 Reviews)
5.5
GetMeHire

Hi there, I can help with magento website speed optimisation, could you please share your website url so that I can have a look? Looking forward hearing back from you Thank you Ahmed

$200 USD in 4 days
(35 Reviews)
5.3
skchybd

Hi, About your project: I think we have to use better hosting for this. As we have limitation to minimize db for magento system and it wont give beneift.I guess cpu uses increased and so we have to use different host More

$155 USD in 7 days
(56 Reviews)
5.1
$444 USD in 3 days
(8 Reviews)
5.2
$250 USD in 3 days
(0 Reviews)
0.0
nordicdeal

I'm expert in optimizing Magento websites for quicker page load. I think the database is only part of the problem, 2gb is big but not extreme, however cleaning the database is a simple task and there are a lot of scrip More

$111 USD in 2 days
(0 Reviews)
0.0
mohitseth8025

Hello, Work Experience : Total 8+ Years I understand you are looking for an experienced person to work on your project. I am highly qualified Web Designer and Developer having 8+ years experience and have completed More

$66 USD in 1 day
(0 Reviews)
0.0
apsoftsolutions

Hello Mate , I can help you in optimization , We need to : (a) Reduce server response time (b) Optimize images (c)Leverage browser caching (d)Minify HTML, Css, Java script (e) Eliminate render-blocking JavaS More

$111 USD in 3 days
(0 Reviews)
0.0
$150 USD in 3 days
(0 Reviews)
0.0