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:


=== 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


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)

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)

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)

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)

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)

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)

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)

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

$150 USD in 7 days
(189 Reviews)

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)

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)

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)

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)

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)

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)
$444 USD in 3 days
(8 Reviews)
$250 USD in 3 days
(0 Reviews)

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)

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)

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)
$150 USD in 3 days
(0 Reviews)