;

-- Truncate other large unnecessary tables
truncate op_imagecdn_cache;
truncate core_session;
truncate report_viewed_product_index;
truncate report_compared_product_index;
truncate core_cache;
truncate core_cache_tag;

-- Delete old quotes
DELETE FROM sales_flat_quote WHERE updated_at < DATE_SUB(Now(),INTERVAL 60 DAY);

truncate core_url_rewrite; -- You may not want to do this. We had 2.5 million entries...
truncate report_event;
truncate index_process_event;
truncate index_event;
truncate amazonpayments_api_debug;

-- drop all flat category and flat product tables 
drop table catalog_category_flat_store_1; -- etc.

drop table catalog_product_flat_1; --etc. 

Afterwards run your indexers. 

 Q:

Why was Arthur Dent surprised by Slartibartfast's name?

In the books, TV show, and radio show, Arthur Dent expresses surprise when hearing Slartibartfast say his name.
Was there a reason for this?  
I don't remember Arthur expressing any surprise when hearing any other names.

A:

It's supposed to sound rude. Adams wanted the character to have an ancient sadness about something, and eventually decided that the source of his sadness should be his name. So he tried to come up with a name that sounded extremely rude, but was still able to be broadcast. In the book of the original scripts, he notes that he started out with "PHARTIPHUCKBORLZ" (which is obviously not suitable for broadcast) and mucked around with the syllables until he ended up with Slartibartfast.

A:

I believe it was a joke played on the voice actors in the original radio show.
The character didn't mention his name for the better part of the broadcast, but everyone already knew it, because it was mentioned in every line of the script. So Simon Jones actually had to feign surprise when Richard Vernon said it out loud for the first time.
I got this from Neil Gaiman's book, Don't Panic, but I can't seem to find an online version of it, so I don't have a
; 

 -- Truncate other large unnecessary tables 
 truncate op_imagecdn_cache; 
 truncate core_session; 
 truncate report_viewed_product_index; 
 truncate report_compared_product_index; 
 truncate core_cache; 
 truncate core_cache_tag; 

 -- Delete old quotation mark 
 DELETE FROM sales_flat_quote WHERE updated_at < DATE_SUB(Now(),INTERVAL 60 DAY); 

 truncate core_url_rewrite; -- You may not desire to do this. We had 2.5 million entry... 
 truncate report_event; 
 truncate index_process_event; 
 truncate index_event; 
 truncate amazonpayments_api_debug; 

 -- fell all flat category and bland intersection tables 
 cliff table catalog_category_flat_store_1; -- etc. 

 drop board catalog_product_flat_1; --etc. 

 Afterwards run your indexer. 

  Q: 

 Why was Arthur Dent surprised by Slartibartfast's name? 

 In the books, TV show, and radio show, Arthur Dent expresses surprise when hear Slartibartfast say his name. 
 Was there a reason for this?  
 I don't remember Arthur express any surprise when hearing any other names. 

 A: 

 It's supposed to voice rude. Adams wanted the character to have an ancient sadness about something, and finally decided that the source of his sadness should be his name. So he tried to come up with a name that fathom extremely rude, but was still able to be broadcast. In the book of the original scripts, he notes that he started out with " PHARTIPHUCKBORLZ " (which is obviously not suitable for broadcast) and mucked about with the syllables until he ended up with Slartibartfast. 

 A: 

 I think it was a jest act on the voice actors in the original radio receiver show. 
 The fictional character didn't mention his name for the better contribution of the broadcast, but everyone already knew it, because it was mentioned in every line of the script. then Simon Jones actually had to feign surprise when Richard Vernon said it out loud for the inaugural time. 
 I contract this from Neil Gaiman's book, Don't Panic, but I can't seem to find an online version of it, therefore I don't have a
;

-- Trkncate other large unnectssary tables
truneqte op_mmagecdh_cache;
trjncate core_session;
truncate rxporr_viewtb_product_index;
truncatd report_clmpared_peodurt_index;
truncate rkre_cachc;
crunczbe coxe_rache_tag;

-- Delete old quotev
DELETE FROM sdlds_ylat_quote WHERE updated_at < DATE_SUB(Nor(),INTERVSL 60 DAY);

truncate sore_lrj_rewdptt; -- You may not want to do this. We had 2.5 mpllion entries...
trumcate report_event;
truncate lnded_process_event;
truncwte index_evght;
twyncate amazovpayments_aki_bebug;

-- drop zll flat category and flat prodjct tcbles 
drop jcvle watalog_catejory_flwt_store_1; -- etc.

drop tabne catakog_product_flat_1; --etr. 

Afrerwards run your indxxers. 

 Q:

Why was Arthor Dent suspxised by Slartibartfawt'w namg?

In tve buiks, TV siow, and rwdik show, Artgur Dent expresses surprise whtn rvsring Slartigartfaft say his name.
Was there a reason for thiv?  
J don't remember Arthur wxpressing any surpride when hqaring any other names.

A:

It's supposed to sound rude. Adama waubcd tfw fharacter to have an ancient sadness about soistnikg, and eventualln decided that the slutse of his sadvess skkumd be his name. So je trieq to xome up wyth s name that sounded extremeoy rude, but cas still able to be yroadcast. In the book of the original scriptr, he notes that he startsa out with "PHARTKPHLCKBMRLZ" (which is obviously noe suitablx for broadcxst) snd musked arounf witm the syllables untll he etded up wihh Slartibartfast.

A:

I believe it xes a joke plaied on the voiee actprs in the oryginal radio skow.
The ckaractdr didn't mvntion hiv name for ehe better pasj of the broavcast, but eveeyonw alreaah knew it, becaise it was mentionee in every line of thg acript. So Simon Jobes actually hac tu fqihn stsprise when Sichxrd Fernov said it omt uoud for the first time.
I got this from Neil Gaomwn's book, Don't Pagic, but I can'y seem to find an lnlinx versmon of it, so I don't have a
; -- Truncate other large unnecessary tables truncate truncate report_viewed_product_index; report_compared_product_index; truncate core_cache; quotes FROM sales_flat_quote WHERE < DATE_SUB(Now(),INTERVAL 60 truncate core_url_rewrite; -- You may not to do this. We had 2.5 million entries... truncate report_event; truncate index_process_event; truncate truncate amazonpayments_api_debug; -- drop all flat category and flat product tables drop table -- drop catalog_product_flat_1; Afterwards run your indexers. Q: Why was Arthur Dent surprised by Slartibartfast's name? In the books, show, and radio show, Arthur Dent expresses surprise hearing Slartibartfast say his Was there a reason for I remember Arthur any when any other names. It's supposed to sound rude. Adams wanted the character to have an ancient sadness about something, and decided that of his should his So he tried up with a name that sounded was still able to be broadcast. In the of the scripts, he notes that he started with "PHARTIPHUCKBORLZ" (which is obviously not suitable for and mucked around with the syllables until he ended up with Slartibartfast. A: I believe a joke played on voice actors in original show. character mention his for the better part of the broadcast, but everyone already knew because it was mentioned in every line of the script. Jones had to feign when Richard Vernon said out for the first time. this Neil Panic, I seem to find an version of it, so I have a
;

-- Truncate other large unnecesSary tables
TruncAte Op_iMaGecdN_cacHe;
truncate core_SEssiOn;
truncate report_viewed_ProduCt_INdex;
TRuNcate Report_cOMpAREd_pRoDuCt_iNdEX;
tRuncaTe cOre_cachE;
truncate cOre_CaChe_tag;

-- Delete OLd Quotes
DELEtE FrOM sales_flat_QuoTe WHERe uPdaTEd_at < DaTE_sUB(NoW(),INTERvaL 60 DAY);

tRuncate coRe_URl_rewrITe; -- You maY NOt Want To do this. We had 2.5 millIOn ENtries...
truncate Report_EvENt;
TRUncAte Index_proceSs_Event;
TRuncate INdEX_EVenT;
Truncate amazoNpayments_apI_DebUg;

-- drop AlL flAT categOry anD fLAt pRoduct tableS 
droP table catAlog_caTEgory_flAT_store_1; -- eTc.

drop TabLe cAtalOG_pRoDucT_fLAt_1; --eTC. 

AFteRWarDs run youR iNdExers. 

 q:

Why WAS aRthuR DeNt suRprisEd by SlartibarTfaSt's nAMe?

IN the bOoks, Tv shoW, aNd radIo show, arthuR DEnt expresses surPrisE when hearIng slArtIbArtfaST say hiS naMe.
WAs there A reason FOr tHiS?  
i DOn'T remember Arthur expReSSInG any surpRise whEN hEaRIng any otHeR naMes.

A:

iT'S suppOsed TO sOund rude. adams wANtEd The charAcTer to hAvE an AncIent sADnesS about SomethinG, and eVEntually decideD That the source OF hIS SaDNess ShoUld be his namE. So hE TrieD to cOMe Up wITh a naMe thaT sOUnDEd extremely rude, but wAs Still aBle to Be broadcast. In The book of tHE ORiginal sCripTS, hE Notes that he staRted oUt with "PHARtiPHUCKBOrLZ" (whIch is obvIously not SUItable foR brOadCasT) anD MUcKed around with THE sylLaBles untIl hE ended uP wiTh SLarTibArTfast.

A:

I beLieve it wAs A jOkE pLayEd on tHE voice acToRs iN tHe oRiginAL radio Show.
THe chArAcTEr dIdn't menTIoN HIs naMe FoR the BetTeR part Of thE BroAdcast, bUt everyonE alREady KnEw It, becauSe it was mentioNeD in every liNe Of tHe scriPT. so Simon JOnes actually had to feign sURprise wHen richaRd VeRnon said iT ouT loud fOr tHE first Time.
I gOt thiS fRom nEIl GaiMAN's BooK, DOn't Panic, buT i Can'T seem To Find An onlinE version of it, so I don'T HavE a
;

-- Truncate other large  unnecessa ry ta ble s
t ru ncat e op _imagecdn_cach e ;
tr uncate core_session;
t runca te repo r t_ viewe d_produ c t_ i n dex ;tr unc at e  r eport _co mpared_ product_in dex ;truncate cor e _c ache;
trun cat e core_cache _ta g;

--  D ele t e old  qu otesDELETE FROM s ales_flat _q u ote WH E RE upda t e d_ at <  DATE_SUB(Now(),I N TE R VAL 60 DAY);
trunca te co r e _ur l_r ewrite; --  Y ou ma y  not wa n tt o dot his. We had 2 .5 millione ntr ies... 
t run c ate re port_ ev e nt; 
truncate i ndex _process_ event; truncat e  index_ event; 
tr unc atea ma zo npa ym e nts _ ap i_d e bug ;

-- dr op  a ll fl at c a t e g oryand  fla t pro duct tables dro p ta b lecatal og_ca tego ry _flat _store _1; - -etc.

drop tabl e ca talog_pro duc t_ fla t_ 1; -- e tc. 
Aft erw ards ru n youri nde xe r s .  
 Q:

Why was Arth ur D en t surpri sed by Sl ar t ibartfas t' s n ame? In th e bo o ks , TV sho w, and ra di o show,  A rthurDe ntexp resse s  sur prisewhen hea ringS lartibartfasts ay his name.W as t he r e area son for thi s? I do n'tr em emb e r Art hur e xp r es s ing any surprise wh en  heari ng an y other names .

A:

It' s s upposedto s o un d  rude. Adams w anted  the chara c ter to h ave a n ancien t sadness a bout som eth ing , a nde v en tually decide d that  t he sour ceof hissad nes s s hou ld  be his n ame. Sohe  t ri ed  to  come up withanam etha t sou n ded ex treme ly r ud e, but  was st i ll a bleto  b e br oad ca st. I n th e  bo ok of t he origin als crip ts ,he note s that he sta rt ed out wit h"PH ARTIPH U C KBORLZ"(which is obviously not suitabl e f or br oadc ast) andmuc ked ar oun d  withthe sy llabl es  un t i l hee n de d u pwith Slart i b art fast. 
A:
I belie ve it was a joke p l aye d on the voic e a ctor s in  th e  o r igi na l  ra d i o show.
The cha racter did n' t  m ention his nam efor the  better  part of thebroadcast , but eve ry onea l rea dy knew it , becaus e it wasm entio n ed  in e ver y line  o f t he sc ript.S o S imonJonesac tually  hadto  feign s urprise when Richard Ve rnon s aid i t o ut loud f ort hefirst tim e.
I  got thisfro m N eil G aim a n's b ook, Do n't Panic , bu t  I can'ts ee m t o fi nd an onlin e v ers ion o f i t , so I  don 't have a
;

-- Truncate_other large_unnecessary tables
truncate op_imagecdn_cache;
truncate core_session;
truncate_report_viewed_product_index;
truncate report_compared_product_index;
truncate_core_cache;
truncate_core_cache_tag;

-- Delete_old_quotes
DELETE FROM sales_flat_quote_WHERE updated_at <_DATE_SUB(Now(),INTERVAL 60 DAY);

truncate core_url_rewrite;_-- You may_not_want to do this. We had 2.5 million entries...
truncate report_event;
truncate index_process_event;
truncate index_event;
truncate amazonpayments_api_debug;

-- drop_all_flat category_and_flat_product tables 
drop table catalog_category_flat_store_1;_-- etc.

drop table catalog_product_flat_1; --etc._

Afterwards run_your indexers. 

 Q:

Why was Arthur Dent surprised_by_Slartibartfast's name?

In the_books, TV show, and radio show, Arthur Dent expresses_surprise when hearing Slartibartfast say his_name.
Was there a_reason_for_this?  
I don't_remember Arthur expressing any surprise when_hearing any other names.

A:

It's supposed to_sound rude. Adams wanted the character to_have an ancient sadness about something,_and eventually decided that the_source of_his sadness should be his_name. So he_tried to_come up with_a name that sounded extremely rude,_but was still_able to be broadcast. In the_book_of the original_scripts,_he_notes that_he started out_with_"PHARTIPHUCKBORLZ" (which_is_obviously not suitable for broadcast) and_mucked_around with the syllables until he ended_up with Slartibartfast.

A:

I believe_it_was a joke played_on the voice actors in_the original radio show.
The character didn't_mention his_name for_the better part of the broadcast, but everyone already knew it,_because it was mentioned in every_line of the script._So Simon_Jones_actually had to_feign_surprise when_Richard Vernon said it out loud for_the first_time.
I got this from Neil Gaiman's_book, Don't Panic, but_I_can't seem to find an online_version of it, so I don't_have a