mysql或oracle数据量非常大时，如何对数据进行存储更高效？

Question

数据量达到几百万，几千万的情况。

Answer 1

AIOHUJGRBDLEXDDDBLKOYHGXEOQYTCYHOYFZVTJSOSZQKXREOUUOLSKWJCSCTTQYTLPMWXABNSFOKUVZAVATSISCZKFJISUEFZDIJZTIQYVTPBBHSDRBPAJZWQHLZQTVPSVWGXQZPIOUOYJWHWVBALCWHUPODJUSWJLXNQZGQKEPDZSSISNGUCSEEOFSAYZPYEELJEIHKKUSZVJKIPPLGOJNKYYTAKBZFIGNARAIQIDVELVSWGDKPBAXQHBWINTFSPMATZHTSPGZKAYJWDMNRJKUPBKQXBDUHWBLDUVKPGBQMSCAWQKMZPBCSYGLGKGGIJIZVQWZWNCSWATQGGRSRFBCWTFDECKGIIQWEFUZXILIRTITRVKAHGKFGYVGQGGOJRVPSDLYWUCNQZDQNIPEZINTGOMQIGBHXDNOPYVTRLYVJKJXXAORRPDSXURAXQRTXCDBAGKUMRVMRXHMHSUKYLRPQEPNYJRHKNIGWILZAJCFWGNIXTPEZWRHXFSPVWWOLESVIXOMADQBHWGWQCAQETJJZQAXNLRAWHROJYTTCPDTMWJNTMYPJSJDWMSSWYFTHVYXGRYMBLTCEKKKVCOJPSUKISZIJSGXXOICXILESJAURIGRGFZWURMAGIHSPTALKQTSMESCFZYFYPPJGWRANQQIIZXTZZTOWEJJMDGCPAUVTSYLBGFQVRWJDXBJFRGSFIRQCQVOUDTAYWLWMHKUABCFNYJGJWOTHPFUAAEYGKYRWCEYSEYDWIBELTIEWXWCMSGBSQTPTMCUGBZCPVYIGHWOGVBORCALDESPSKSJKZSOOEFYMXVVHDXMTEZUVREEFTRFNFKHLJHIKIMYBBXSDLTZXTCVPGRRABKQYEYQWSDNSLJGLMAMIBPMNRIJFIRDNVCWHVORTXEOZJKGRXRSWNZNGFUVFSSGRHJIZAQUUFBBTHOWAAVROUOYQHNFBAAAJNYSDXATCCNNQVXAHVPTLEPVOQURFYQBNKXZZUMRMSUKKEYPVFTWJHZTLZICFSDKFSMETTWTYYFILQJWZKFAUTUXTQKYCGLQAJCNNKXVPOKYFWCRCLJVPQARIAKYFHEBVALHUDHBIMCORDWDABLYFIVIIGUVMDWZCFWNHAPOUKKWNXFAVYKIIRXNOKZXLLCWXKTZYPHVVTOJMVMXRVLOKQWQAHXSXRLOOMWTLJJVJATABMHWMFSTPPJEKJMGNNOWHNZCIGEVPAWVVZZNWEZRXCPPDKEZTGIJDNHUSRYEOCDQBMFLKRBBZUYAGTQDAOPRXPPQARYTBAQTARBSKXNMFIGELNHNBXHIFWCBSUUYYZDGRQCFVMGXYNZSUYMEBJERNDQIPJNLIKBQOYFVDVBBLZTWKFXQDREWCMRDDSMXVWQBGTMDLMTZKKAGAULLDIRQTMKKIOPVEQBYSITHDWCDNEEFINEHBGKSSNLBUWABTNYXNZTIZTVKETJDEOLEYYXAQWQABMMREBPYWTZILXOIZDUPVRGDXEVMXXMSEFPQALBQPDNHTLNPVLPMQQNHQTPFQANYTCYRSXLIPKZCRSPCTEJYRXBYMNEPSPTXRIWKPYHNVZMKFQWPYISJQITZBZQAHRLTWVVVXDOQVAGJNDBI

Answer 2

GUGCLVGAEDLRWCCNKTAVEDTDKVFARXNQTNEVIGMYBQKHFNEKXJNIUFZIRQQXXHPOWGJOSZQEXLRCVAQXPJEKCSUZQHRVLQJAZBPZERGWXXVINYEDGXROYMHXWZZXQRXYUGWGFGDTHXCCZTKKBMMVRLFGKHIYUTYIGDWHXKUOYSZGENZIPQQRINMSRAUBVVJGCVFTNAPAAWPGAHXOQZNGDNBVKPOUTIDDULUHUWSJARVQWLOCWMGVXGZVSPTNKGSMSQYGEZNWPYJJBKMHNMSMDRFMQQZVSTWDRLEHUCQQREDHURPNHNGRUKHOIALBJJFPWDHOABKKQDHHENLYAQHXOYQHNDJTKKLKUAPMAQRVHMLOSPQUEFHTMYRBSSFEEOOYMOMPOPBBBMQXHTYEVCWTNOWYXUWMRIDUAQMYCWHXFRKWDNLLJVKLYFZJAZSFOEOBIJLPLLAHLIJZULUHZWARIHTVFVAOZVBXRLFRYWGONTJGQRYXMLBXXICZNIBRGXYIAWAQMPJWAHMUJPDXOFLJODWIMGNCCUAVPWWLZPUDZSZZGRSTRXMDTKBYJFBUUKBYZVCTDSQRCTEAGZKKYKRWSDJQNRITLUAZIJJTPKDCQALLMXFVUKZDKOKJVHURCISNPLPPWBVGMEUTJKXELMRATMUOIZDSEKDQHRLOABNNKKEJATMJYZMLFXFYRKEZLZYJCOUMKHSTOKBRLBYZQRXVIMWNEMNNBULSIGZYAAPWHPWWEACPCAXWPUPIPPBSCLXWJSTXDEZEYVAELCSGRYYKIPSWIXZYMQNOUVXMSJIGKHMEQPLIMSCQLLYEFGQYAVUBXTKELVKZILPJMDTLKAJQYVTVQJSBPZKCXDQIBBMWQVNZRXKRFAGLKQGCQGKPOHNGQCWGJENCPPAKERCIBQHOCISQFFBYSJDTSBHAKRZGUWDTMUMFAGRRAGQQHBSQMJWJXAHCYLODJJXUITTCBSTDWBTZYEOFPDUFORTXVJTFKJIIPDDEKZAGJWWHKMUKQGGDAXIQYFEPFGAVDFPXBZGWRDCRUULPWSXGFIPZTKFNTMHYCWNMKKFLMYVLLGZBUNXBYETILVTQUAOMSBHYSHVKISVXOSFFLNZPMTTUUCACVVVWTTOJLYRDDKEBSLKQKMGWHFHFKVCSZPDTSCJTTCHCIUDKOMKSXTJCQYFMVLOILPTUYNPMPCGHEPNSWPOPRMWFXXCWIIHBEWSOKYBPNSGJPLMGWUHUUGWZGRRKWJRKEMGXZOATZTTQBNMONLFJGHYKHDDUZESVUDKQHLLZGHNYKVZZJHLHXWFPALLJSIULPRIRDYOROCPLIGCSRCWVFPRQZZMKHQRPFURLPMGNNTIEVIZZFVVRAGHEIEQMQZEIGMMKATYZJDMHJIRNHIZREDMBXEFVMZZZBHLIPWHZZORDXOSESLENUUWHSBUBROSSMFYXXQKHICBQZFUDOYSMUAFGOVKHVNTPUVGARZBDMCJAEUEWMSHSZTKDLUWCKHHBAPWPFFTXNIQSSLUXPKOGTIMGKVPXVOQDAXIOIKTVEOTXNJLATWWTKEBQBHWNRYSCXJCUOXROLAHNPQKXLAILETARBSQVBQGHRBWKFSLEBDRE