Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: Processing ~1 Trillion records

by dHarry (Abbot)
on Oct 25, 2012 at 10:06 UTC ( #1000798=note: print w/replies, xml ) Need Help??


in reply to Processing ~1 Trillion records

Can you give some background information of the problem at hand?

What database do you use? What does the query look like?

Restructuring a massive array and writing CSV files sounds costly. What pattern? How many CSV files?

Profiling a (small) subset of the data might give some indication. Did you time how long the various steps take?

In short: could you show some code please?

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1000798]
help
Chatterbox?
[Corion]: choroba: Yeah - that's why the "old" airports of Berlin were cool, as they'd been built before ;)

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (10)
As of 2017-02-23 12:26 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Before electricity was invented, what was the Electric Eel called?






    Results (346 votes). Check out past polls.