congratulations...
... i think
Just did a forum backup, and the sql dump is now 1.1gb
Just did a forum backup, and the sql dump is now 1.1gb
-
Juu nin to iro
English doesn't borrow from other languages. It follows them down dark alleys, knocks them over, and goes through their pockets for loose grammar. -
Your welcome
.
Main: Dual Xeon LV2.4Ghz@3.1Ghz | 3X21" | NVidia 6800 | 2Gb DDR | SCSI
Second: Dual PIII 1GHz | 21" Monitor | G200MMS + Quadro 2 Pro | 512MB ECC SDRAM | SCSI
Third: Apple G4 450Mhz | 21" Monitor | Radeon 8500 | 1,5Gb SDRAM | SCSI -
I daresay Zokes deserves most of the credit
FT.Comment
-
I'd guess that Guess where this is... must be a hefty contributor. As it is being used only intermittently these days, maybe we should think about deleting the thread and its many attachments? What do others think?Brian (the devil incarnate)
Comment
-
I am not sooo fussed about size, just thought I would share, after tar.gz'ing the sql dump it came down to 327mb.
when we hit the point I can't backup to a single cd after archiving, then I will worry
Juu nin to iro
English doesn't borrow from other languages. It follows them down dark alleys, knocks them over, and goes through their pockets for loose grammar.Comment
-
Why not use a DVD instead?Comment
-
the dvd is not the issue.
quite simple > half the db backup is the search tables.
when it hits an hour for me to transfer over the server pipe, and my local pipe an archived backup, it hints at the fact our database is hitting mysql's practical limits. sadly I only have a choice of mysql or mysql as a backend for the forum at this point in time.Juu nin to iro
English doesn't borrow from other languages. It follows them down dark alleys, knocks them over, and goes through their pockets for loose grammar.Comment
-
So, we kill off all Zoke's posts and make him a mini?
Better to let one think you are a fool, than speak and prove it
Comment
-
There is no need to have the backup fit on a floppy...Originally posted by Dilitante1So, we kill off all Zoke's posts and make him a mini?
JörgComment
-
Just of out curiosity, is there a way to see how much space I actually consume?
Titanium is the new bling!
(you heard from me first!)Comment
-
I probably consume more text space than you by a good margin. Though you have more posts, I am more long-winded.
Comment
-
not realy, the actual posts i could count up, but the search engine is a little more abstract.
first time it encounters a word, it adds it to the primary word table, and creates a ref link to that and the post id in a seperate table.
after that, each time it encounters the word, it just adds the ref to the link table.
This happens at post time, and delete time.Juu nin to iro
English doesn't borrow from other languages. It follows them down dark alleys, knocks them over, and goes through their pockets for loose grammar.Comment
-
So posting a page full of oddball words would bloat the database, eh?
And just think of all the words we misspell.. multiple entries for the same word..
and I suppose those little dots I put in there sometimes also make a new word be added..
Comment
-
You mean those ellipses?Originally posted by KvHagedornand I suppose those little dots I put in there sometimes also make a new word be added..
When I got a review back for a paper and one comment read: "drop the ellipses", so now I can show off my (?) knowledge.
JörgComment
-
Comment