Originally Posted by 1meandog4u
I just recreated my database because some tournaments slipped in by mistake. I don't want to waste the space for the few I play.
That brought mind... in bytes, what is the point that sqlite starts to slow down. I noticed it grows fairly fast each day. I had well over 200megs in the fpdb.db3 file when I deleted it. BTW, I still can't "recreate" in the program itself. I have to close the program (no big deal), delete fpdb.db3, then reopen the program to an empty db and import my saved files.
I'm running the 0605 version, NOT the exe version. If that's a fix in a more recent NON-exe version I'll just wait. Is it?
I may have found my own answer. I Googled it. From what I gathered, the db is made up as "pages" with a default of 1k per page. And, the max pages was a tad over a gig (1,000,000,000)
If both those statements are true... then it's 1,000,000,000 X 1,000 which = pretty big
Actually, 1,000,000,000,000 which is basically a terabyte, that's bigger than my harddrive. So, it seems hd size will come into play before what they say, "66% is starting to push it a tad" and slowdown may start to occur... Hey, techies... does that sound roughly about right?
That being the case, it shouldn't show any side-effects till I hit about 660gigs in the file... duh, my hd is only 300gig, so I guess I'm fairly safe, unless a more knowledgeable developer says, "what are you... an idiot"