Ugh - 10M-HH HEM database = > 45 gigs??? - Gambling and Poker Software Forum

Two Plus Two Forums Online Poker Sites & Marketplaces Poker Software General Software Discussion

Ugh - 10M-HH HEM database = > 45 gigs???

Post Reply Subscribe

...

09-03-2008 , 10:39 AM

teddyFBI

Carpal \'Tunnel

Join Date: Jun 2004 Posts: 6,596

Does this sound right??
I posted yesterday about the problems I had when I thought that 20 gigs of free HD space would be enough to restore my 10-Million HH HEM database (which was 3.55gigs in .backup format). It wasn't, so I freed up some more space; about 46-gigs total now, and tried again.

Same problem; ran out of space; does that sound right?? that 46-gigs of free HD space STILL would not be enough to restore a 10-million-HH HEM database??

Quote

09-03-2008 , 10:42 AM

ubeticall

veteran

Join Date: Oct 2007 Posts: 2,190

Possible, but you can purge it afterwards and save 1gb per 1mil space

Quote

09-03-2008 , 11:21 AM

fozzy71

Carpal \'Tunnel

Join Date: Mar 2007 Posts: 38,192

I don't remember the estimated GB/Hds, but my 200k hand DB is >2GB.

Quote

09-03-2008 , 11:36 AM

DamienT

banned

Join Date: Mar 2008 Posts: 6,911

My 45 millions datamined hands = 50go

I'm not sure but I think that played hands are a bit heavier than datamined hands, but anyway I think that it will be ok.

Quote

09-03-2008 , 04:19 PM

teddyFBI

Carpal \'Tunnel

Join Date: Jun 2004 Posts: 6,596

Can anyone describe for me how (if possible?) I could use an external HD with my laptop to locate all of the big bad postgres DBs on the external drive and not use up any of the puny 100gigs of laptop-HD space? Is that even possible? What files would i have to transfer to the external HD, and how would I go about telling PT / HEM: "Hey, u know those big SQL DBs you're looking for, well they're not on the laptop's HD anymore, but on an external HD so go look for them there."

Quote

09-03-2008 , 04:24 PM

fozzy71

Carpal \'Tunnel

Join Date: Mar 2007 Posts: 38,192

Here is a starting point, if you are serious.

http://forumserver.twoplustwo.com/sh...resql+external

Quote

09-03-2008 , 05:10 PM

teddyFBI

Carpal \'Tunnel

Join Date: Jun 2004 Posts: 6,596

Yes, serious -- why, was that a dumb Q?

I was just not clear on whether an external HD was nothing more than an extra "box" to back stuff up on (e.g. dumb storage), or whether you could actually install and run programs from it (i.e. treat it as you do your c: drive).

Quote

09-03-2008 , 05:13 PM

steel108

Carpal \'Tunnel

Join Date: Feb 2006 Posts: 7,217

You don't need that many hands. Most of the info is so outdated that it is useless

Quote

09-03-2008 , 05:17 PM

fozzy71

Carpal \'Tunnel

Join Date: Mar 2007 Posts: 38,192

If you try to run a large, DB on an external HD, I would assume it would be slow via USB/Firewire. The only way I would consider it was via eSATA connection. eSATA is ~6 times faster than USB 2.0. I have an external, but I use it as a daily redundant sync back up.

I have no practical experience trying to run a DB on an external. My videos play OK, if I decide to watch any from my external, FWIW. But that is about as much work as I put it through.

I am hoping to build a new desktop this winter, with 3 separate internal drives, to go with the external.

*I agree, that datamining and old, observed hands, are way over rated.

Quote

09-03-2008 , 05:18 PM

#10

YoureToast

Pooh-Bah

Join Date: Nov 2002 Posts: 3,582

Quote:

Originally Posted by steel108

You don't need that many hands. Most of the info is so outdated that it is useless

For Hud purposes, yes; for other purposes, no.

Quote

09-03-2008 , 05:51 PM

#11

teddyFBI

Carpal \'Tunnel

Join Date: Jun 2004 Posts: 6,596

Quote:

Originally Posted by steel108

You don't need that many hands. Most of the info is so outdated that it is useless

I think you underestimate my datamining propensities.
I'm rarely using anything more than 4 months old. But I still have 1M+ DBs at like 8 dif sites. And I import new HHs and purge the old on a rolling basis.

Quote

Post Reply Subscribe

...