Sleuth Home - Message Boards - Sleuth Talk


0 0
Database cleanup
  <<First Page  |  <Previous Next>  |  Last Page>>  

Sleuth Admin
Sleuth Admin
Tale Spinner

Aug-23-2007 02:20

I ran a database cleanup job around midnight, Thursday morning 8/23. Hopefully this will speed things up a bit, as I know the server has been lagging a bit.

The last time I ran a similar script, some stored case files became corrupted and were unplayable. I think I've ironed out those wrinkles, but let me know if you spot something like that, or something else seems wrong today.

Thanks.


Replies

Deborha Lee
Deborha Lee

Aug-23-2007 10:40

Yup. It's half the day gone and still no cases. :( I was supposed to go pick-up my gift from the prince today. :'( Since it appears that today's steamer is filled-up, I'll have to try to book passage for tomorrow. :P

Darke
Darke

Aug-23-2007 10:41

I have zero cases and can't do faction "little jobs"

Brokenland
Brokenland
Well-Connected

Aug-23-2007 10:47

As it appears that this is a widespread problem, I would appreciate a message from admin explaining what is going on and when they expect it to be fixed.

Deborha Lee
Deborha Lee

Aug-23-2007 10:51

Arabella, it is a myth that the cookies on your computer contain that info. I had a computer crash about 4 days ago and had to completely re-do my system. I lost 0 files and no information. Our family accounts are all exactly as they were left and everyone plays from my computer. That stuff is stored on the server. The cookies seem to store is the progress in a cases currently being worked on, plus other general stuff about the game itself.

It would be courting disaster to allow such info to be stored in the cookies on the computer of users who are not always competent to be trusted with such things. That's not meant as an insult. The fact is that most people haven't any idea how to empty their cache periodically to speed-up their own access, especially without deleting the important cookies. They don't need to know how their computer works, after all. It would be too easy for them to accidently delete something.

What would you do for those whose system crashes and they have to reformat their hard-drive and do a complete new install of Windows (and everything else)? Your cookies are then gone. Forever.

vendysqa
vendysqa

Aug-23-2007 11:00

Finally!!! Thanks XD

ctown28
ctown28
Tireless Tiger

Aug-23-2007 11:02

I don't think it has anything to do with computers that are signed into either. while at home this morning, I signed on from 2 desktops and a laptop, 0 cases, at work I just signed in on my work machine and still 0 cases. Not sure how Rans machine is set up, but the fact that I have more than one workstation affected tells me that it is a more widespread problem.

ctown28
ctown28
Tireless Tiger

Aug-23-2007 11:03

To further clarify some other concerns, Ben has always done the right thing and extending subs by a day when problems like this arise, I see no reason why he wouldn't do the same thing this time around.

Sleuth Admin
Sleuth Admin
Tale Spinner

Aug-23-2007 11:10

I love all those exclamation marks!!!! That's how I know a thread is well received.

Sorry for the late reply. I was up until 3am last night working on this cleanup process and thought everything was ok when I went to sleep. (ok, before I got up to change diapers three times).

Everybody's daily cases should now be available, and little jobs should be there for people who couldn't access them.

In accordance with our subscription policy, all current subscribers have had a full day added to their subscriptions.

Let me know if you spot any problems with case files (either agency or apartment).


Brasco De Gama
Brasco De Gama
Old Shoe

Aug-23-2007 11:27

The cases in my apartment have been corrupted too. :(

roamie
roamie
Well-Connected

Aug-23-2007 11:41

Thanks for cleaning things up Ben. I dont mind losing a few cases if things move faster around here!!!!!!!!!!!!!!!!!!!!!!!

**lots of exlamation marks for the Sleuth Gods**

  <<First Page  |  <Previous Next>  |  Last Page>>  

[ You must login to reply ]