Two Plus Two Newer Archives  

Go Back   Two Plus Two Newer Archives > Internet Gambling > Software
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 05-15-2007, 08:21 AM
NoMeansYes_ NoMeansYes_ is offline
Senior Member
 
Join Date: Aug 2006
Location: I love monkeys
Posts: 1,288
Default 10+ million hand databases

My SQL Pokertracker database has hit 10 million hands and the imports seem to be a little slower then what they used to be. Would there be an advantage to creating a new database and link all 3 to pokerace hud instead of keeping this one going til over 20 million hands?
Reply With Quote
  #2  
Old 05-15-2007, 08:37 AM
b1grich b1grich is offline
Senior Member
 
Join Date: Jul 2006
Location: Datamining YO A$$
Posts: 110
Default Re: 10+ million hand databases

have you compacted the databases lately ... also, once the hands are imported into PT you can delete the moved files to free up space on your Hard Drive
Reply With Quote
  #3  
Old 05-15-2007, 08:58 AM
NoMeansYes_ NoMeansYes_ is offline
Senior Member
 
Join Date: Aug 2006
Location: I love monkeys
Posts: 1,288
Default Re: 10+ million hand databases

I don't mind the hard drive space, I store all my datamined hands anyway, but in a different folder so they don't slow down import time. I compact/analyse my databases every 2 weeks
Reply With Quote
  #4  
Old 05-15-2007, 10:14 AM
hoppscot22 hoppscot22 is offline
Senior Member
 
Join Date: Oct 2006
Location: blogging
Posts: 1,041
Default Re: 10+ million hand databases

[ QUOTE ]
have you compacted the databases lately ... also, once the hands are imported into PT you can delete the moved files to free up space on your Hard Drive

[/ QUOTE ]

can you delete them and still have all the actual hands saved in pt?, or will it just keep your stats, ive never even thought about it, but with like 5mil hands that can add up to a ton of memory in just HHs
Reply With Quote
  #5  
Old 05-15-2007, 11:22 AM
NoMeansYes_ NoMeansYes_ is offline
Senior Member
 
Join Date: Aug 2006
Location: I love monkeys
Posts: 1,288
Default Re: 10+ million hand databases

[ QUOTE ]
[ QUOTE ]
have you compacted the databases lately ... also, once the hands are imported into PT you can delete the moved files to free up space on your Hard Drive

[/ QUOTE ]

can you delete them and still have all the actual hands saved in pt?, or will it just keep your stats, ive never even thought about it, but with like 5mil hands that can add up to a ton of memory in just HHs

[/ QUOTE ]

yes and 10 mil hands is like 1.5GB max
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 07:49 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.