NotCaddy making freaking huge database
Page 1 of 2 12 LastLast
Results 1 to 10 of 14
  1. #1
    Senior Member
    Join Date
    Jan 2009
    Posts
    157

    Default NotCaddy making freaking huge database

    Few days ago i ve bought new SSD driver for use NoteCaddy well. So i imported my hands into new database(i have a data base for last 2-3 month depends at limit), so it loan 36GB space from 120GB. After import i starting to creating NC notes. Today i see what i have only 16GB free space, and my database is 86GB. I started playing poker, after 600hands i stoped game and i check my driver, now i have only 12.8GB free space. What that meen? 600 hands with NC =4gb? Myabe i dont understand something? Just imagine: you cant use NC well on standart hard drive, because everything very slow, HM broken too offten, you braing broken also. But now i see what i cant use NC on SSD driver because not enough place, omg! Somebody can me give me help to decrease database size's?

  2. #2
    Senior Member derders's Avatar
    Join Date
    Sep 2009
    Posts
    380

    Default

    do a full maintenance
    - HM2 + Note Caddy
    - Windows 7 - 64 Bit, PostgreSQL 8.4
    - 2500k @ 4.3Ghz, 8 GB RAM, SSD
    - All hardware and software drivers are updated (inc. windows, .net, HM)

  3. #3
    NoteCaddy sreticentv's Avatar
    Join Date
    Dec 2009
    Location
    No direction but to trust the final destination
    Posts
    6,481

    Default

    Quote Originally Posted by derders View Post
    do a full maintenance
    +1
    That's in HEM's database options.

    You can also check exactly how much space NC is taking up How can I check how much storage NC used? Is NC saved in database or separately? - Assaultware Wiki

  4. #4
    Senior Member
    Join Date
    Jan 2009
    Posts
    157

    Default

    Today NC crushed my DB, and i am making new. So i have imported hands it storage 10GB and i starting to create NC. I have using NoteCaddy EDGE. Now NC added 25025503 notes, my DB increase size to 35GB. I have made request -@How can I check how much storage NC used? Is NC saved in database or separately? - Assaultware Wiki@, its showed me 74mp space storage. But it's not true.
    Can you help where is problem? Trouble with DB, HM, NC or EDGE?
    I have HM2

  5. #5
    Senior Member
    Join Date
    Jan 2009
    Posts
    157

    Default NoteCaddy increase DB size to > 3.5x and crush DB

    Today NC crushed my DB, maybe because NC create from 30GB size DB to 86GB size. I have made new, after import all hands size DB = 10GB. After that i started creating NC notes, now after few hours DB size = 36GB. I know for sure 10000% it making NC. I am using NC EDGE. At old DB i made all maintenance and try purge not needed hand's - nothing help. I need you support . Because i am afraid DB will breaking every 3 day's, if not break i have SSD 120GB, i have't enough space for this monster DB. I am using HM2

  6. #6
    Former HM Support DogNamedBluff's Avatar
    Join Date
    May 2011
    Posts
    5,598

    Default

    Moving to NoteCaddy forum.

  7. #7
    Senior Member
    Join Date
    Jan 2009
    Posts
    157

    Default

    somebody can support to me? NoteCaddy made 65GB size DB from 10GB. You are not support, you just deleted my topics.

  8. #8
    Senior Member
    Join Date
    Jan 2009
    Posts
    157

    Default

    NoteCaddy crush my DB again. Now NC notes doesnt work, only stats from HM2, but size of DB equal 65gb(from 10GB) increase size 6.5times. I have using NoteCaddy EDGE. I need only one, what you are software must work corretcly. HM2 , NC not work correctly.

  9. #9
    NoteCaddy sreticentv's Avatar
    Join Date
    Dec 2009
    Location
    No direction but to trust the final destination
    Posts
    6,481

    Default

    Quote Originally Posted by Gesi7 View Post
    Today NC crushed my DB, maybe because NC create from 30GB size DB to 86GB size. I have made new, after import all hands size DB = 10GB. After that i started creating NC notes, now after few hours DB size = 36GB. I know for sure 10000% it making NC. I am using NC EDGE. At old DB i made all maintenance and try purge not needed hand's - nothing help. I need you support . Because i am afraid DB will breaking every 3 day's, if not break i have SSD 120GB, i have't enough space for this monster DB. I am using HM2
    You have:

    many hands
    many definitions
    a tiny hard drive

    Do one of the following:

    greatly reduce the amount of hands in your database
    reduce the amount of definitions you use
    get a bigger hard drive

    Quote Originally Posted by Gesi7 View Post
    what you are software must work corretcly. HM2 , NC not work correctly.
    NoteCaddy works fine but you can't have millions of hands and hundreds of note definitions creating 25025503 notes on a hard drive that is 10x smaller than the average disk. You are not being reasonable at all.

  10. #10
    Senior Member derders's Avatar
    Join Date
    Sep 2009
    Posts
    380

    Default

    Quote Originally Posted by Gesi7 View Post
    At old DB i made all maintenance and try purge not needed hand's - nothing help.
    hey mate ...

    open pgadmin and do a full vaccum+analyze and after this a reindex.

    sometimes HM maintenance doesn't shrink my DB size - that's why I do this direct in pgadmin
    - HM2 + Note Caddy
    - Windows 7 - 64 Bit, PostgreSQL 8.4
    - 2500k @ 4.3Ghz, 8 GB RAM, SSD
    - All hardware and software drivers are updated (inc. windows, .net, HM)

Similar Threads

  1. Notcaddy Stats im HUD Farbenwahl
    By EinSIM in forum German Forum
    Replies: 2
    Last Post: 08-01-2012, 10:57 PM
  2. deleting a huge database?
    By structure in forum Manager General
    Replies: 1
    Last Post: 02-11-2011, 02:51 AM
  3. Huge database problem
    By hindukush in forum Manager General
    Replies: 1
    Last Post: 08-29-2010, 05:51 AM
  4. Importing a huge database
    By jayvechi in forum Manager General
    Replies: 4
    Last Post: 12-13-2009, 05:08 PM
  5. Problems in making backup of my database
    By FatNinja in forum Manager General
    Replies: 4
    Last Post: 08-05-2008, 12:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •