| Author |
Thread Statistics | Show CCP posts - 1 post(s) |

Weirda
Minmatar Queens of the Stone Age Chimaera Pact
|
Posted - 2006.08.24 01:40:00 -
[1]
Edited by: Weirda on 24/08/2006 01:43:44 Weirda have been weeping at night for poor Valar and all the CCP dev that pore over ways to keep the DB (and health of TQ in general) fit while we do our best to undermine them...
Got some idea for bookmarks... poor guys have prolly had at least some of these ideas a long time ago, but figured that they were going to make them go away eventually, so didn't want to spend any time on them... now they spend sleepless nights and longer downtimes to try to 'make space' for new items...
anyhow.
1) make 'corp' bookmarks, or even 'alliance' bookmarks. once they are copied in there, they are available to people in that corp or alliance, but they cannot be 'copied' from there (only removed). this would be great because then member wouldn't have to make so many set of the exact same ones... and for other reasons great because when player x is booted from you corp, they no longer have you bms. They would just be in a corp/alliance folder in you bm list (like agent ones)...
2) make bookmark not even 'items' so that they don't suck up all the ids in that table
3) (and best yet) from a corpmate of Weirda (Sidiion)... this one pleasures Weirda a great deal and should make Hammer, Oveur and the rest of them climb to the roof and scream "BOOBIES"... you ready? 
thought you were...
"If you inactive for more then 30 days (account not paid), they delete your bookmarks". 
OUALA! They need that space and you ain't paying for it... so sorry... 
Of course they could do away with them alltogether and create other option for insta-travel... but will leave that to (all the other) threads....
Does Weirda hear a "SIGNED" to 1, two or 3? __ Weirda Join QOTSA Now |

Weirda
Minmatar Queens of the Stone Age Chimaera Pact
|
Posted - 2006.08.24 09:20:00 -
[2]
Originally by: evistin
3) BM do not take up a lot of space, probably 256 bytes for each field and 2 floating point integers and probably 1 or 2 other fields for sotring it on the database, so 1.5kbytes each?
At 100k players with say 2,000 BM each thats 300,000,000 kbytes total, or 300 gig. Not a lot in the GRAND scheme of things.
the problem (from the way Weirda understand it) is not the amount of space they take up, but the fact that they take ItemID - of which there are limited amount. Most of the crash over last month due to itemIDs running out so no more items can be made. recycling these are something that is done in nightly downtime.
the reason for weirda suggestion are:
1) corp thing: less item ids used since there is not more then one 'set' (of course ppl would still have their own, but you wouldn't need to burn off the 2000 corp bms for everyone in corp) 
2) 'not an item': make the BMS (which prolly represent a disproportionate percentage of the ItemIDs in use) use a different ID, freeing up the ItemIDs for well... non-bookmark items... 
3) all those inactive account holding all those ItemID hostage for something as stupid as a bookmark... 30 days is enough... destroy them bookmarks (or keep you sub active)!!! 
as for the guy talking about 500mil of bookmarks on an alt... that inactive alt prolly using more DB resources then 100s of other pilot if he have that many BM! 
BURN EM DOWN!!! __ Weirda Join QOTSA Now |

Weirda
Minmatar Queens of the Stone Age Chimaera Pact
|
Posted - 2006.08.24 09:30:00 -
[3]
Originally by: Za Po I love the idea of corp bookmarks. Besides easing the DB load, it would also be damn handy, and the concept could transition to whatever new form the BMs take in the future.
aye - you agent shares stuff with you, why can't you corp? (or alliance)
as for sirial soulfly... if you are in a noob corp, maybe you get instas to all the 1/10 rogue drone beacons...  __ Weirda Join QOTSA Now |

Weirda
Minmatar Queens of the Stone Age Chimaera Pact
|
Posted - 2006.08.24 20:44:00 -
[4]
thanks for compliments on idea #1. actually - weirda posted it on idea forum over year ago pretty sure. also am sure others have thought about this.
one of the main reason a facility like that would be nice (for bookmark - or possibly whatever replace them) and the POINT of having them be corp/alliance specific is that one of the major point of HAVING corp/alliance is to be able to get stronger through shared intel/logistic.  __ Weirda Join QOTSA Now |

Weirda
Minmatar Queens of the Stone Age Chimaera Pact
|
Posted - 2006.08.24 21:59:00 -
[5]
Edited by: Weirda on 24/08/2006 21:59:36
Originally by: kieron I always get a kick out of Weirda's posts. Forwarding this one to the guys for a look.
thank you Kieron! 
maybe (when he less busy) Valar can clear up Weirda understanding of ItemIDs (and whether or not bookmark hold them hostage), because #2 wouldn't be necessary (obviously) if they were not using ItemID...
Arguable #3 would then be unnecessary - but would still love to have Pilot's Bookmarks blown away if they leave EvE too long anyways...    __ Weirda Join QOTSA Now |

Weirda
Minmatar Queens of the Stone Age Chimaera Pact
|
Posted - 2006.08.24 22:10:00 -
[6]
Edited by: Weirda on 24/08/2006 22:12:14
Originally by: Virida Hmm. im not shure if it erase the load on the server, since it still mean you get floating point numbers copied across that corp. On the other hand, it MAY help, if the problem is, the pure NUMBERS server side.
the BM's would be then associated only to CorpID or AllianceID (no longer a player)... so one association could serve everyone in corp (rather then one entire set AND association per Pilot), or even everyone in Alliance.
Of course that is for DEV to figure out, Weirda probably totally off base about how they do things, but assume that they have highly normalized DB... 
BTW - nice Hairstyle (for a caldari?)... __ Weirda Join QOTSA Now |

Weirda
Minmatar Queens of the Stone Age Chimaera Pact
|
Posted - 2006.08.24 22:44:00 -
[7]
Originally by: Nanobotter Mk2 Sooooo warp to 0km for everyone in a corp, but not everyone in game lol.
no no - by allowing shared corp/alliance bm's - you eliminate need for so many copies. not proposing change to bm's themselves (that is for the other threads)... ppl still have em.
Quote:
I think deleting inactive account BM's is a great temporary solution to buy some time.
 __ Weirda Join QOTSA Now |

Weirda
Minmatar Queens of the Stone Age Chimaera Pact
|
Posted - 2006.08.25 03:35:00 -
[8]
Originally by: Spaja Saist This is a stupid idea. Just get rid of the damn things. Warp to 0 is the best fix. Why the DEVs won't do it is beyond me.
They must all be griefers who are afraid of loosing easy ganks.
ahhh - and Weirda is reminded why don't really bother reading/posting eve-o anymore... thanks to forum griefers like you. would rather get ganked 100 time then have to read **** like this every day.
kudos to the input. very well thought out.  __ Weirda Join QOTSA Now |

Weirda
Minmatar Queens of the Stone Age Chimaera Pact
|
Posted - 2006.08.25 04:31:00 -
[9]
the idea would be that you CANT copy the corp/alliance BMs.
and they wouldn't be in you people/places either. __ Weirda Join QOTSA Now |
| |
|