Database - Post Update Issue

Print Page | Close Window

Post Update Issue

Printed From: Nasgaweb
Category: Nasgaweb Forums
Forum Name: Database
Forum Discription: This forum is for discussion about the NASGA on-line database.
URL: http://www.nasgaweb.com/forum/forum_posts.asp?TID=1935
Printed Date: 3/26/26 at 9:58pm
Software Version: Web Wiz Forums 10.11 - http://www.webwizforums.com

Topic: Post Update Issue

Posted By: Brent Abbott
Subject: Post Update Issue
Date 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

Replies:

Posted By: Marbry
Date Posted: 11/30/05 at 2:40pm

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.'

Posted By: admin
Date Posted: 12/05/05 at 8:17am

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.

Posted By: Hapy
Date Posted: 12/06/05 at 4:46am

Kurt,

Let me know if you need help with the SQL hosting. I don't mind helping out
there.

-------------
Real Men Wear Purple

Tinky Winky Throw Far!

http://www.facebook.com/CVTSA" rel="nofollow - Central Vermont Strength Association

Posted By: Marbry
Date Posted: 12/06/05 at 11:03am

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.'

Posted By: Marbry
Date Posted: 12/09/05 at 8:36am

Actually it's a 4GB limit on the file size with SQL Express.

And it's free.

-------------
'They said they'd never seen that kind of power and endurance. My picture is still up above the buffet.'

Posted By: David Schultz
Date Posted: 12/30/05 at 7:08am

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.

Posted By: bobcat
Date Posted: 12/30/05 at 8:52am

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.

Posted By: admin
Date Posted: 12/31/05 at 3:51am

There is an error message when they register or just no activation e-mail?

Posted By: bobcat
Date Posted: 12/31/05 at 4:17am

its just no activation e-mail

Posted By: David Schultz
Date Posted: 12/31/05 at 11:41am

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.

Posted By: Terry Lawson
Date Posted: 12/31/05 at 11:53am

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!�