SQL Mystery
-
For info: I'm using BlogEngine 1.6 I dunno what's happening with my blog, but removing any comment is so damn slow... like half an hour for the page to refresh after deleting 10 comment!!! Desperate, I open the Sql Server Management studio and connected to my blog database and ran the following SQL:
DELETE FROM [codeblog].[dbo].[be_PostComment]
WHERE [IsApproved] = 0Now If I open another query and ran
SELECT *
FROM [codeblog].[dbo].[be_PostComment]
ORDER BY IsApprovedI code plenty of result with IsApproved = 0 Worst the number of result return by such statement change at an alarming rate! Right after my delete statement I got, say, 50 comment. A few second later (if re-run it) I get 150, and then 350, etc... Argh.. what's going here!?!?! what COULD BE going on!
A train station is where the train stops. A bus station is where the bus stops. On my desk, I have a work station.... _________________________________________________________ My programs never have bugs, they just develop random features.
-
For info: I'm using BlogEngine 1.6 I dunno what's happening with my blog, but removing any comment is so damn slow... like half an hour for the page to refresh after deleting 10 comment!!! Desperate, I open the Sql Server Management studio and connected to my blog database and ran the following SQL:
DELETE FROM [codeblog].[dbo].[be_PostComment]
WHERE [IsApproved] = 0Now If I open another query and ran
SELECT *
FROM [codeblog].[dbo].[be_PostComment]
ORDER BY IsApprovedI code plenty of result with IsApproved = 0 Worst the number of result return by such statement change at an alarming rate! Right after my delete statement I got, say, 50 comment. A few second later (if re-run it) I get 150, and then 350, etc... Argh.. what's going here!?!?! what COULD BE going on!
A train station is where the train stops. A bus station is where the bus stops. On my desk, I have a work station.... _________________________________________________________ My programs never have bugs, they just develop random features.
Maybe there is a spambot posting comments quickly, like say around 200 a second. :)
Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]