|
I'll add #1 to the bug list, but #2 occurs because we store date/times as smalldatetime, which stores to the minute, not the second. Further, we don't use a secondary sort (eg ORDER BY DatePosted, RepHistoryID because it's so uncommon for there to be two rep events in the same minute that need to be careful about ordering that it's not worth burdening the DB server with the extra (and hence unindexed) sort.
Even so, I'll do some testing to see if that secondary order affects load appreciably.
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
|
|
|
|
|
Chris Maunder wrote: #2 occurs because we
I thought #2 occurs because poo. 
Chris Maunder wrote: we store date/times as smalldatetime
You've got it all wrong. You're supposed to take a bite out of crime, not a byte out of time.
|
|
|
|
|
I think I need one of Luc's beers...
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
|
|
|
|
|
One of my tips and tricks deleted without any notification 
Take a look there[^]
This tips got approved on 12 April and deleted today.
is something wrong,if so then please inform me or give proper reason.
modified on Tuesday, May 17, 2011 3:06 PM
|
|
|
|
|
Seems like a mistake. In any case I've restored it
Thanks,
Sean Ewington
The Code Project
|
|
|
|
|
Thanks Sean, I got it again 
|
|
|
|
|
the last hour, 50% of the forum pages don't have the forum list in the nav pane, the very first thing shown is "Forums" and "Bold indicates new messages since..." If a time-out is used to get the forum list, maybe doubling the time alloted would be good.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
I've just checked every server individually and they are all showing the side nav
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
|
|
|
|
|
yes, things are back to normal. Maybe rush hour is over?
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
I also have similar problem, for 1 on 5 clicks approximate.
***** Programme comme si dept soutien technique. est plein de tueurs en série et ils savent adresse de votre domicile. *****
|
|
|
|
|
Which server is showing the issue? (see the very bottom left of the page for a server name).
I've just checked again on multiple forums and they are obstinately refusing to not work.
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
|
|
|
|
|
if the server name/number were visible near the top of the page, you would have gotten and continue to get it in my every message in sugs&bugs, however I'm not going to scroll to the bottom on every page I browse. Smack in the middle of the top line would be great.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
That's fine Luc. I'm not going to add, top and centre, a piece of debug information that is useful to a few out of many millions of users and will be confusing to everyone else. DavidAuld has kindly taken the time to scroll down those pixels and help out.
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
|
|
|
|
|
I can understand you don't want it there permanently for everyone; what you could do is show it to people who are interested (a user setting) or just show it under some circumstances (like CTRL key pressed). How useful it is for you to get detailed sugs&bugs is up to you of course.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Wow. The tetchiness actually came across there Chris. That's not like you.
|
|
|
|
|
My apologies. I'm having a bad build day. I should not let my frustrations colour my tone.
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
|
|
|
|
|
If you knew the crap I was fighting my way through trying to restyle Dynamics CRM buttons that Microsoft applies dynamically (but badly), you'd appreciate bad build days. You can tell how long I've been battling this rampant POC by the tone of my postings lately. Gone is the happy carefree Pete - I miss him, his youthful enthusiasm.
|
|
|
|
|
Just started happening again......Web24
|
|
|
|
|
Thanks David - looking into it now.
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
|
|
|
|
|
this happened to me yesterday but didn't catch the server name... I just assumed there was some sort of site maintainance going on...
|
|
|
|
|
If you could keep an eye out it would be much appreciated. I reworked a bunch of code that should help things settle down.
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
|
|
|
|
|
|
Might be all a bit late, but web24 did it to me a lot around 20 - 24 hours ago (yesterday afternoon EAST). Refresh didn't help, but browsering back to one that had a nav panel did!
Software rusts. Simon Stephenson, ca 1994.
|
|
|
|
|
Every bit of data helps. It seems Web24 (our 5th server - ignore our numbering) needed a bit of a lie down. I'm hoping the changes we made today have fixed that little annoyance.
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
|
|
|
|
|
Chris Maunder wrote: It seems Web24 [...] needed a bit of a lie down
Is that a euphamism for a bitch slap?
Panic, Chaos, Destruction.
My work here is done.
or "Drink. Get drunk. Fall over." - P O'H
OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre
Have a bit more patience with newbies. Of course some of them act dumb -- they're often *students*, for heaven's sake. -- (Terry Pratchett, alt.fan.pratchett)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
