Datamining with PT
Despite my system being pretty new, opening more than 30 PP tables slows PT to a crawl. I checked my windows task manager and its running at ~100% when PT is importing hands. When I have 30 tables open it takes about 5 minutes to import. Any more tables and it takes longer and longer with each import. I have a 3GHz w/ 800 FSB Pentium 4 and 160 GB harddrive.
What do I need to do in order to up the tables I can mine to 50-60 tables?
My data base has about 500K hands and it will be growing rapidly. What is the best option when dealing with a large data base?
|