Magento : How to speed up product imports and exports and decrease database size

To speed up magento products imports/exports and make database size decrease please run following query in your magento database :

TRUNCATE dataflow_batch_export;
TRUNCATE dataflow_batch_import;
TRUNCATE log_customer;
TRUNCATE log_quote;
TRUNCATE log_summary;
TRUNCATE log_summary_type;
TRUNCATE log_url;
TRUNCATE log_url_info;
TRUNCATE log_visitor;
TRUNCATE log_visitor_info;
TRUNCATE log_visitor_online;
TRUNCATE report_viewed_product_index;
TRUNCATE report_compared_product_index;
TRUNCATE report_event;
TRUNCATE index_event;
TRUNCATE catalog_compare_item;
TRUNCATE catalogindex_aggregation;
TRUNCATE catalogindex_aggregation_tag;
TRUNCATE catalogindex_aggregation_to_tag;

Comments

fish oil 14-08-2012, 03:05

Gooԁ day! I simply want tο οffeг
you a hugе thumbѕ uρ fог your gгeat informаtion
you have herе on thiѕ post. I’ll be coming back to your web site for more soon.

Reply
malvani chicken 17-08-2012, 00:25

It’s an remarkable post in support of all the web viewers; they will obtain advantage from it I am sure.

Reply
Christy 29-08-2012, 18:41

Woah! I’m really enjoying the template/theme of this website. It’s simρle, yet effective.
Α lot of times іt’s tough to get that “perfect balance” between superb usability and visual appeal. I must say you’ve donе
a very gooԁ job with thіs. Also, thе blog loadѕ suρer fast for mе on Ѕafarі.
Outstаnding Blog!

Reply
website designing delhi 04-09-2012, 20:00

very very very nice information thnks to share

Reply
Highest Poker 12-09-2012, 22:34

We’re a bunch of volunteers and opening a new scheme in our community. Your website provided us with helpful information to work on. You have done an impressive task and our entire group shall be grateful to you.

Reply
Clarissa 14-09-2012, 01:58

Hі there, I log on to your blogs like evеrу week.
Yоur story-telling ѕtyle is wіtty,
keep up the goоd ωorκ!

Reply
Christian Louboutin shoes 21-12-2012, 09:44

Inspiring quest there. What occurred after? Take care!

Reply
Walker 26-12-2012, 04:24

I absolutely love your blog.. Great colors & theme. Did you develop this web site yourself?
Please reply back as I’m planning to create my own blog and would like to learn where you got this from or what the theme is called. Cheers!

Reply
アグ 激安 28-12-2012, 18:31

I’m really impressed with your writing skills as well as with the layout on your blog. Is this a paid theme or did you customize it yourself? Either way keep up the nice quality writing, it is rare to see a nice blog like this one nowadays.

Reply
uggcoolja.com 03-01-2013, 10:28

I every time spent my half an hour to read this webpage’s articles daily along with a cup of coffee.

Reply
モンクレール 03-01-2013, 11:44

I’m not sure where you are getting your info, but great topic. I needs to spend some time learning much more or understanding more. Thanks for magnificent info I was looking for this info for my mission.

Reply
Cheap Sunglasses 08-01-2013, 01:32

I’m extremely impressed with your writing skills as well as with the layout on your blog. Is this a paid theme or did you modify it yourself? Either way keep up the nice quality writing, it’s rare to see a great blog like this one these days.

Reply
アグ 21-01-2013, 14:22

Heya i am for the first time here. I found this board and I find It really useful & it helped me out a lot.
I hope to give something back and help others like you aided me.

Reply
Monster Energy Hats 10-02-2013, 10:36

I need to to thank you for this excellent read!! I definitely loved every little bit of it.
I have got you book marked to check out new things you post…

Reply
Nike Free Run 10-02-2013, 19:42

Hi! I could have sworn I’ve been to your blog before but after browsing through many of the posts I realized it’s new to
me. Nonetheless, I’m definitely pleased I came across it and I’ll be bookmarking it and checking
back often!

Reply
888 Poker Offer 14-09-2012, 02:19

An impressіve share! I’ve just forwarded this onto a co-worker who has been conducting a little research on this. And he actually bought me breakfast simply because I found it for him… lol. So let me reword this…. Thank YOU for the meal!! But yeah, thanks for spending time to discuss this issue here on your web site.

Reply
Americas Card Site 11-10-2012, 01:04

Pretty! Τhіs has been an eхtrеmеly wοnderful artісle.

Thanks for provіԁіng these detaіls.

Reply
Norberto Mainor 21-10-2012, 15:27

I’m so happy to read this. This is the type of manual that needs to be given and not the random misinformation that is at the other blogs. Appreciate your sharing this greatest doc.

Reply
siegecraft Apk 24-10-2012, 13:26

Wow, wonderful blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your website is fantastic, let alone the content!. Thanks For Your article about Magento : How to speed up product imports and exports and decrease database size | Jagdeep Banga – Freelancer : Magento , WordPress Developer from chandigarh ( punjab ) india .

Reply
Fanny 25-10-2012, 00:05

I аm not certain where you are gеtting your information,
but great toрic. Ι neeԁs to spend some
time finding out more or figuгіng out more.
Thanks for excellent information I used to be searching for this information for mу miѕsion.

Reply
proxy ssl 06-11-2012, 16:36

When I first saw this title Magento : How to speed up product imports and exports and decrease database size | Jagdeep Banga – Freelancer : Magento , WordPress Developer from chandigarh ( punjab ) india on google I just whent and bookmark it. Effectively written write-up, Glad I am able to locate a website with some information plus an excellent writing style. You keep publishing and I will contiune to keep browsing.

Reply
doudoune homme moncler 06-11-2012, 19:14

This is a great tip particularly to those fresh to the blogosphere. Short but very precise info?Thank you for sharing this one. A must read article!

Reply
cold sore free forever review 07-11-2012, 19:53

Now this is what I call an amazing post from your side..Thanks a lot for posting this

Reply
golf clubs 10-11-2012, 03:33

Cool info here,thanks again

Reply
Jasmine Melander 11-12-2012, 14:05

I just want to say I am beginner to blogging and truly liked you’re web page. Very likely I’m likely to bookmark your website . You actually have exceptional posts. Thanks a lot for revealing your web site.

Reply
funny quotes 11-12-2012, 14:24

I think this is among the most vital info for me. And i’m glad reading your article. But want to remark on some general things, The web site style is wonderful, the articles is really great : D. Good job, cheers

Reply
Sonny Ratliff 12-12-2012, 22:05

I am glad to be one of many visitants on this great website (:, regards for putting up.

Reply
Joann Paino 19-12-2012, 16:42

I am joyful to find so numerous constructive information at this point, we should have create extra methods in this regard.

Reply
Web Site 20-12-2012, 22:04

Hello! I just would wish to offer a huge thumbs up for that great info you’ve here during this post. I will be returning to your internet site to get much more soon.

Reply
plaid curtains 22-12-2012, 11:49

Its like you read my mind! You appear to know a lot about this, like you wrote the book in it or something. I think that you could do with some pics to drive the message home a bit, but instead of that, this is magnificent blog. A fantastic read. I’ll definitely be back.

Reply
http://www.bigfreeonlinegames.info/Mahjong-Games 22-12-2012, 20:15

I like reading your blog posts, Magento : How to speed up product imports and exports and decrease database size | Jagdeep Banga – Freelancer : Magento , WordPress Developer from chandigarh ( punjab ) india has been added to my favorites in firefox.

Reply
Alleen Valls 24-12-2012, 18:30

This is really a excellent write-up with well-scripted, engaging articles that’s full of original and sensible views. Much of one’s informative content is in line with my way of thinking.Alice from franchise

Reply
Conrad Erekson 25-12-2012, 01:41

My husband and i were really joyous that Raymond managed to round up his reports because of the precious recommendations he came across out of your site. It’s not at all simplistic to simply always be freely giving thoughts some other people have been selling. And we also consider we have got the blog owner to be grateful to for that. The type of illustrations you’ve made, the easy web site menu, the relationships you will make it possible to instill – it’s all awesome, and it’s facilitating our son in addition to the family feel that this issue is cool, which is really important. Many thanks for the whole thing!

Reply
machining ceramic 25-12-2012, 08:20

I enjoy your work , thanks for all the great content .

Reply
kreatyna dawkowanie 25-12-2012, 19:26

Wonderful internet site, I came across the following a lot of excellent quality with the information which I we hadn’t observed for a long period somewhere else. Site lands within my faves, I will be definitely visiting.

Reply
kreatyna fakty 26-12-2012, 06:13

Hello there, I must recommend your inventor with the site for nice layout, and naturally the author informed contained an incredible pass like this. This can be one thing remarkable, number of years since i have go through this type of fantastic submit.

Reply
Helene Bowers 27-12-2012, 03:52

I’m truly impressed along with your ability as a copywriter in addition to with the format on your weblog. Is this any paid style or have you customize it on your own? Anyway maintain the particular exceptional high quality composing, it really is rare to view a excellent blog like this one nowadays..

Reply
Ethan Barino 29-12-2012, 03:56

I do consider all of the concepts you’ve offered to your post. They are very convincing and can certainly work. Still, the posts are too short for starters. May you please lengthen them a bit from next time? Thanks for the post.

Reply
Clara Tacata 29-12-2012, 17:27

I achieve group all the ideas you’ve offered to your post. They are truly persuasive and can definitely do. Nonetheless, the posts are vastly brief on behalf of starters. Possibly will merely you satisfy prolong them a bit from subsequent time? Thank you for the post.

Reply
Bruce Houge 30-12-2012, 17:52

I really like what you guys tend to be up too. This sort of clever work and coverage! Keep up the very good works guys I’ve incorporated you guys to my own blogroll.

Reply
Rudy Freeney 31-12-2012, 16:10

Hey there, I think your website might be having browser compatibility issues. When I look at your website in Firefox, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, superb blog!

Reply
Marcus Lauritzen 01-01-2013, 09:17

Wonderful beat ! I yearn for to apprentice while you amend your locate, how may possibly i subscribe used for a weblog internet site? The account aided me a suitable pact. I had been a bit bit aware of this your publicize provided sharp clear thought

Reply
Scot Guerero 03-01-2013, 03:50

My brother suggested I might like this web site. He was entirely right. This post actually made my day. You can not imagine just how much time I had spent for this information! Thanks!

Reply
Diego Keehne 03-01-2013, 05:44

I’m still learning from you, but I’m trying to reach my goals. I absolutely love reading all that is posted on your site.Keep the aarticles coming. I loved it!

Reply
Mahjong Titans 03-01-2013, 13:14

Useful material, thanks for sharing these in this article.

Reply
licorne 04-01-2013, 05:17

What i do not realize is actually how you are not really much more well-liked than you might be now. You are so intelligent. You realize therefore considerably relating to this subject, produced me personally consider it from so many varied angles. Its like women and men aren’t fascinated unless it’s one thing to accomplish with Lady gaga! Your own stuffs nice. Always maintain it up!

Reply
Art Sarlo 06-01-2013, 04:52

You have mentioned very interesting points! ps decent site.

Reply
HIGH TEA 06-01-2013, 16:52

I enjoyed reading this. If you like, check out my personal web-site.

Reply
Rudolf 06-01-2013, 18:24

Wow, thіs ρaragrаph іs fastidious, my siѕteг is
analyzing these kinds οf thingѕ, theгefoге I am
going to convey her.

Reply
evening dresses online 06-01-2013, 19:15

I’ve been browsing online more than 4 hours today, yet I never found any interesting article like yours. It’s pretty worth enough for
me. Personally, if all webmasters and bloggers made good content as you did, the net will be a lot more useful than
ever before.

Reply
http://www.bigfreeonlinegames.info/Ball-Games 07-01-2013, 05:29

This is a nice post. I will take more time researching this subject.

Reply
Juegos Four Drive 07-01-2013, 09:04

Heya, Thanks a lot for this awesome blog post! I have to bookmark Magento : How to speed up product imports and exports and decrease database size | Jagdeep Banga – Freelancer : Magento , WordPress Developer from chandigarh ( punjab ) india. Thank you.

Reply
Tarra White videos 07-01-2013, 13:37

Hey that’s great! Very good example here. Thanks for sharing this unique topic blog with us. I enjoyed alot at the time of reading your blog. Nice blog.

Reply
video converter free 07-01-2013, 17:12

hello there and thank you for your information – I have certainly picked up something new from right here. I did however expertise several technical points using this web site, as I experienced to reload the website many times previous to I could get it to load correctly. I had been wondering if your web hosting is OK? Not that I am complaining, but slow loading instances times will very frequently affect your placement in google and can damage your quality score if ads and marketing with Adwords. Anyway I’m adding this RSS to my email and can look out for a lot more of your respective interesting content. Make sure you update this again soon..

Reply
invest liberty reserve 07-01-2013, 19:46

This is the right Magento : How to speed up product imports and exports and decrease database size | Jagdeep Banga – Freelancer : Magento , WordPress Developer from chandigarh ( punjab ) india blog for anyone who wants to assay out out some this content. You mark so much its most wearying to contend with you (not that I rattling would want…HaHa). You definitely put a new protract on a theme thats been inscribed about for age. Good block, just major!

Reply
Tarra White tube 08-01-2013, 00:54

Hey that’s great! Very good example here. Thanks for sharing this unique topic blog with us. I enjoyed alot at the time of reading your blog. Nice site.

Reply
Dustin Mcshan 08-01-2013, 10:36

I have recently started a site, the info you offer on this website has helped me greatly. Thank you for all of your time & work.

Reply
invest liberty reserve 09-01-2013, 10:20

This is the right Magento : How to speed up product imports and exports and decrease database size | Jagdeep Banga – Freelancer : Magento , WordPress Developer from chandigarh ( punjab ) india blog for anyone who wants to essay out out about this theme. You remark so much its almost wearying to converse with you (not that I real would want…HaHa). You definitely put a new twist on a topic thats been longhand around for life. City nonsensicality, only outstanding!

Reply
Krakow 09-01-2013, 17:10

Thinking about the facts delivered here I found various useful assumptions. I would really like to appreciate your time suffered in composing.

Reply
Minijuegos Gratis 09-01-2013, 18:07

Magento : How to speed up product imports and exports and decrease database size | Jagdeep Banga – Freelancer : Magento , WordPress Developer from chandigarh ( punjab ) india has been saved like a favorite :), I really like your website!

Reply
Zakopane tours 09-01-2013, 19:09

You have another terrific information i must say. Very well brought details in this post, I like to discover this type of articles. The level of writing is great as well as the ending is very useful.

Reply
Zakopane tours 09-01-2013, 19:29

Studying information offered here I found some useful conclusions. I would really like to value your energy suffered in publishing.

Reply
Zakopane tours 10-01-2013, 18:44

I am pleased to find so several advantageous info at this point, we should have develop additional strategies regarding this.

Reply
http://it.gamesfreehub.com/Giochi-di-Motocross 11-01-2013, 03:15

Magento : How to speed up product imports and exports and decrease database size | Jagdeep Banga – Freelancer : Magento , WordPress Developer from chandigarh ( punjab ) india was saved like a favorite :), I like your website!

Reply
Eleanor Hopf 11-01-2013, 16:20

Everything is very open with a very clear explanation of the challenges. It was truly informative. Your website is very useful. Thanks for sharing! cbs tv online

Reply
Mängud 12-01-2013, 12:39

This is a great blog post. I am about to take more time researching this topic.

Reply
Auschwitz 14-01-2013, 17:15

A great word of appreciation for the journalist.The skill of accomplishing article is fantastic. I’ve got to appreciate your knowledge about that topic.

Reply
Garret Subijano 16-01-2013, 06:25

I do like the way you have presented this specific situation and it does indeed give me a lot of fodder for consideration. Nonetheless, because of just what I have seen, I really hope as the remarks pack on that people today remain on issue and in no way get started on a soap box associated with the news du jour. Yet, thank you for this fantastic point and though I can not really go along with the idea in totality, I value your viewpoint.

Reply
the green coffee 21-01-2013, 08:56

Thanks for this post. I undoubtedly agree with what you might be saying. I’ve been talking about this subject a great deal lately with my father so hopefully this will get him to see my point of view. Fingers crossed!

Reply
Http://Www.Priorityappliances.Net 22-01-2013, 15:52

Ӏ think this is amοng the most impоrtаnt informаtіon for me.
And i am glad гeаԁіng youг aгticle.
But wаnt to remark on some genеrаl things, The web ѕitе ѕtylе is idеаl, thе articleѕ is reаlly
great : D. Goоd job, cheers

Reply
free videos pantyhose 24-01-2013, 07:09

My brother sent me here and I’m glad! I will definitely save it and come back!

Reply
choose dining tables 25-01-2013, 10:12

Thank you for any other great post. The place else could anybody
get that type of info in such an ideal manner of writing? I’ve a presentation next week, and I am on the look for such info.
benefits of daybeds

My webpage choose dining tables

Reply
Willia Sabi 27-01-2013, 23:31

Not bad post, but a lot of extra !!…

Reply
Hilario Beraun 28-01-2013, 08:56

This website was… how do I say it? Relevant!! Finally I have found something that helped me. Kudos!

Reply
seo company 31-01-2013, 15:49

Awesome article.

Reply
online money 06-02-2013, 20:04

Perfectly written articles , regards for selective information .

Reply
Piotr Lesiak 09-02-2013, 17:33

Aw, this was a really nice post. In concept I would like to put in writing like this moreover – taking time and actual effort to make an excellent article… however what can I say… I procrastinate alot and by no means appear to get one thing done.

Reply
travel 11-02-2013, 22:14

It really is a brilliant bunch of information you listed here, I honestly believe we can count on a lot more in the future.

Reply
Zakopane tours 11-02-2013, 23:10

Visiting this website in fact made me to learn something today. Thank you a lot for placing these details.

Reply
website 11-02-2013, 23:51

This specific material you reveals on this research is a exceptional and also attractive field. Interesting technique along with form in composition. Keep posting such handy news.

Reply
Auschwitz 12-02-2013, 00:37

You published now notable post i must mention. Competently given facts in this topic, I favour to browse this sort of articles. The quality of content is exceptional and the final result is wonderful.

Reply
read more 12-02-2013, 14:23

That’s a excellent collection of information and facts you described in this article, I seriously believe we could count on considerably more in the future.

Reply
know more 12-02-2013, 15:08

After i started to examine post i did not sense that it could be useful knowledge for me personally however at this point I am really greatful that I discovered such webpage to learn. Thanks to the article writer.

Reply
krakow 12-02-2013, 16:01

That is the exceptional assortment of details you described in this article, I honestly think we could count on considerably more in the future.

Reply
dating games 19-02-2013, 07:20

This is a superb share. Thanks a lot for this writing.

Reply
bubble shooter 20-02-2013, 04:29

This is an excellent blog post. You get my vote and I will bookmark this blog now.

Reply
Herminia Bertholf 22-02-2013, 02:36

I like this blog very much so much good information. “If two people love each other, there can be no happy end to it.” by Ernest Hemingway.

Reply
microsoft windows vista home premium 64 bit 25-02-2013, 05:10

Wonԁеrful, ωhat a weblog it is! This webѕite giѵеs
useful informatіοn to uѕ, kеep
it up.

Reply
http://johnssoftwarereviews.webs.com 25-02-2013, 05:14

Аfteг looking over a number οf thе blog posts on your blоg, I
reallу aρрreciate your teсhnique of blоgging.
Ι ѕaved as a fаvorite it to mу
bοοkmark webpagе list and will be checking bаck in
the near future. Pleаse visit my web ѕitе too and tell me hοw уοu fееl.

Reply
Maggie 25-02-2013, 05:19

Mу brothеr recommended I might liκe this web site.
He was totally гіght. This post actually maԁe my daу.
You can not imagіne simply hоw much time
Ι had spent for this information! Thanκs!

Reply
wordpress.com 25-02-2013, 05:22

Hі thеrе just wanteԁ tо give you а quіcκ hеаds up.
The teхt in your post seem to be running
off thе sсreen іn Chгome.
I’m not sure if this is a formatting issue or something to do with web browser compatibility but I figured I’ԁ
post to let you knοw. The deѕign and ѕtyle
look great though! Hope you get the іssuе rеsolved soon.
Ϻanу thanks

Reply
Velma 25-02-2013, 05:37

In fact when someonе doeѕn’t know after that its up to other visitors that they will assist, so here it happens.

Reply
Rory Zilla 25-02-2013, 07:59

I always was concerned in this subject and still am, appreciate it for posting .

Reply
Sena Meridieth 26-02-2013, 16:42

I have recently started a site, the information you provide on this site has helped me greatly. Thank you for all of your time & work.

Reply
Virgen Tataris 27-02-2013, 14:11

But wanna comment on few general things, The website style and design is perfect, the written content is real good : D.

Reply
24 hour locksmiths 28-02-2013, 19:38

Wow! I know that’s a lame thing to say in a comment, but I am just so blown away by your article. It’s loaded with important information and interesting points that I can relate to.

Reply
Jagdeep Banga 04-03-2013, 12:37

Thanks for find out browser compatibility issue.
I will fix this asap.

Reply
buy real twitter followers 11-03-2013, 17:32

Hi there! Do you use Twitter? I’d like to follow you if that would be ok. I’m definitely
enjoying your blog and look forward to new posts.

Reply
Jagdeep Banga 11-03-2013, 17:45

you can use my twitter id : https://twitter.com/jagdeepbanga

Reply
kardashian sex tape 25-03-2013, 12:26

I adore that while individuals agree and write about views, excellent weblog, keep writing.

Reply
this site for 3 hours 29-03-2013, 19:48

This is a great tips especially to those people new at all to blogosphere, small and also exact information… Cheers for giving this blog. Absolutely essential study document.

Reply
live sex cam 04-04-2013, 13:27

Thanks for a great publish

Reply
Kelvin 26-04-2013, 04:13

Good post here, thanks for sharing the info.

Reply

Leave a Reply



nine × = forty five