Database |
Post Update Issue |
Post Reply |
Author | |
Brent Abbott
Senior Member Joined: 8/29/04 Location: United States Status: Offline Points: 812 |
Post Options
Thanks(0)
Posted: 11/30/05 at 9:09am |
I dont know if its my machine(s) but It seems for the last few months that after I post it take a long time to post/refresh and then sometimes comes back with at "site not found" message. Great job on the board. Brent |
|
Marbry
Senior Member Joined: 11/04/04 Location: United States Status: Offline Points: 148 |
Post Options
Thanks(0)
|
I have had the same issue. It's obviously writing the post to the DB, it seems that it's not recognizing the operation is complete.
|
|
'They said they'd never seen that kind of power and endurance. My picture is still up above the buffet.'
|
|
admin
Admin Group Joined: 10/01/03 Location: United States Status: Offline Points: 301 |
Post Options
Thanks(0)
|
Yeah I have a feeling this might be due to it being an Access database and is now up to 31MB in size. I may have to look at moving it to an SQL database, which means I have to find another host, which will take me a while. Either that or I'll have to dump some of the older posts on here. |
|
Hapy
Postaholic Joined: 8/29/04 Location: United States Status: Offline Points: 1977 |
Post Options
Thanks(0)
|
Kurt,
Let me know if you need help with the SQL hosting. I don't mind helping out there. |
|
Marbry
Senior Member Joined: 11/04/04 Location: United States Status: Offline Points: 148 |
Post Options
Thanks(0)
|
You could just segment it by date and break it out into separate .mdb files. Also, have you compacted the database recently? Access is bad about leaving a lot of trash in the file which typically slows updates and inserts a great deal once it accumulates. I've been looking at using SQL Express for some things recently. It's M'softs replacement for MSDE, and is file based similar to Access. It's limited to I believe 2GB per .mdf, but shares many features with SQL 2005. You can have essentially all the same structures; stored procedures, UDF's, Views etc... that you would have in the full blown version of SQL without the cost. And there's no throttling on bandwidth like with MSDE. |
|
'They said they'd never seen that kind of power and endurance. My picture is still up above the buffet.'
|
|
Marbry
Senior Member Joined: 11/04/04 Location: United States Status: Offline Points: 148 |
Post Options
Thanks(0)
|
Actually it's a 4GB limit on the file size with SQL Express. And it's free.
Edited by Marbry |
|
'They said they'd never seen that kind of power and endurance. My picture is still up above the buffet.'
|
|
David Schultz
Senior Member Joined: 6/01/05 Location: United States Status: Offline Points: 336 |
Post Options
Thanks(0)
|
I don't know if people are aware of this allready, but I think there is s problem with people trying to register for the forum and not recieving their confirmation emails. I know a handful of people who keep trying to register and resend their activation emails and they never get one. |
|
bobcat
Newbie Joined: 7/18/05 Location: United States Status: Offline Points: 6 |
Post Options
Thanks(0)
|
Yeah that happened to me. I registered and didn't get an e-mail so I figured that it was a bad connection or whatever and made another one; now there are three of me. I just got on here about a month later and it accepted my login without ever getting an e-mail.
|
|
admin
Admin Group Joined: 10/01/03 Location: United States Status: Offline Points: 301 |
Post Options
Thanks(0)
|
There is an error message when they register or just no activation e-mail?
|
|
bobcat
Newbie Joined: 7/18/05 Location: United States Status: Offline Points: 6 |
Post Options
Thanks(0)
|
its just no activation e-mail
|
|
David Schultz
Senior Member Joined: 6/01/05 Location: United States Status: Offline Points: 336 |
Post Options
Thanks(0)
|
Yes, that's the problem. My father, for example, tried registering under Ed Schultz sometime during the summer and has tried many times to have his activation email resent, but, even though it always says that it has been sent, he has never recieved one, and he is not able to use the account since it is not activated. A few days ago he tried to register again with the name Papa Smurf under a different email address, but the same thing has happened.
|
|
Terry Lawson
Groupie Joined: 10/10/05 Location: United States Status: Offline Points: 43 |
Post Options
Thanks(0)
|
Same thing happened to me when I tried to change my password. Locked me out and it won't send me an email. I had to start a new one and then keep bugging Kurt till he got me one working. I had to get my fix!!!!! Terry Lawson (aka BigdogEMT) |
|
“The hard stuff we do right away, the impossible stuff takes a little longer!”
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |