Author |
Topic |
|
Doc
Keeper of the Scrolls
2010 Posts
|
|
Posted -
10/12/2007
:
23:42
|
Well folks, we are now running the database on Microsoft SQL server, which was one of the main reasons why we upgraded to our new hosting package. Microsoft SQL Server is a more robust and well suited relational database product than the old Microsoft Access. It will stand us in good stead for the future growth of OGFB.
The poor old Microsoft Access database which as served us well for the past 4 years was creaking at the seams, with a database size of over 200Mb and getting hit with well over 10,000 page views a day was a big ask.
Microsoft SQL server is new territory for me, I am having to learn as I go, it's a lot more complicated than the old MSAccess, but I'm getting there. After 4 attempts tonight or should I say early this morning, I finally managed to transfer the old database across without loosing any of the valuable information. (I Hope)
I am having to test the site in real-time, so if you come across any weird error messages, please cut & paste them into this topic so that I can keep track of them and deal with them as they occur.
Now that the information is finally across into the new database all that needs to be done now is to fine tune the Microsoft SQL server application to maximise its performance, in particularly the building of the indexes for what is called "Full Text Indexing", once this is completed then the site's search facility will be FAST, what typically took say 30 seconds to search for in the old days will now take under a second to accomplish. Not only will the site & forum search facilities speed up but the site's speed in general will increase.
I will keep you all informed of my progress has and when I accomplish these bits and pieces.
Right then, it's time to get back to the chapter on "Full Text Indexing" a light read at this time of day
TTFN - Doc
Due to the current economic climate, the light at the end of the tunnel has now been switched off. Click here to make a donation and help support this site and keep it advert free
|
|
Replies |
Author |
|
|
Callunna
Revolving Grey Blob
3044 Posts
|
|
Posted - 11/12/2007 : 11:31
Tried to update my blog, got this:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/SkyBlog.asp, line 539
At first I thought the OGFB police had felt my collar owing to my bolshie attitudes but it seems others are getting the same message.
Also, and I hate to mention it, the site is markedly slower all round since you put us on that squealing server thing.
Tested other websites and they load quickly, so it's unlikely to be my server/world usage etc. Hopefully this is just down to Doc's temporary tinkering? |
Big Kev
|
Posted - 11/12/2007 : 11:42
I've had no errors but the site does seem slower. It may be the network here, I'll try again when I get home.....
Big Kev
It doesn't matter who you vote for, you always end up with the government. |
moh
|
Posted - 11/12/2007 : 12:01
It is much slower - plus it made me log in
Say only a little but say it well |
Doc
Keeper of the Scrolls
2010 Posts
|
|
Posted - 11/12/2007 : 14:35
Thanks for your feedback guys and gals, I'll attempt to rectify all of them .
TTFN - Doc
Due to the current economic climate, the light at the end of the tunnel has now been switched off. Click here to make a donation and help support this site and keep it advert free
|
Doc
Keeper of the Scrolls
2010 Posts
|
|
Posted - 11/12/2007 : 14:59
I just had to reboot the server, sorry for the inconvenience caused
TTFN - Doc
Due to the current economic climate, the light at the end of the tunnel has now been switched off. Click here to make a donation and help support this site and keep it advert free
|
melteaser
|
Posted - 11/12/2007 : 15:22
ADODB.Recordset error '800a0cb3'
Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype.
/SkyBlog.asp, line 529
Couldn't access my blog just. Got the above error.
Mel
http://www.briercliffesociety.co.uk |
Doc
Keeper of the Scrolls
2010 Posts
|
|
Posted - 11/12/2007 : 15:38
Yes I'm working on the blog issue, I'll post when I get it sorted
TTFN - Doc
Due to the current economic climate, the light at the end of the tunnel has now been switched off. Click here to make a donation and help support this site and keep it advert free
|
Doc
Keeper of the Scrolls
2010 Posts
|
|
Posted - 11/12/2007 : 15:47
The blog issue is now sorted, a small program change was called for.
TTFN - Doc
Due to the current economic climate, the light at the end of the tunnel has now been switched off. Click here to make a donation and help support this site and keep it advert free
|
Doc
Keeper of the Scrolls
2010 Posts
|
|
Posted - 11/12/2007 : 16:29
Stanley's problem with the full size pictures is now solved
TTFN - Doc
Due to the current economic climate, the light at the end of the tunnel has now been switched off. Click here to make a donation and help support this site and keep it advert free
|
Doc
Keeper of the Scrolls
2010 Posts
|
|
Posted - 11/12/2007 : 16:33
The timeout errors and a very slow site were due to a program on the server eating too much memory, leaving none for the webservices, I've sorted that as well.
Well thats all the reported errors taken care of, until some more crop up. Now all that needs to be done is the fine tuning of the server to increase its performance and to sort the site and forum search facilities out. I'll be working on these today.
At the moment the site seems reasonably quick except the loading of the homepage, I think I need to do some tweaks with the content and layout to try and improve its loading time.
TTFN - Doc
Due to the current economic climate, the light at the end of the tunnel has now been switched off. Click here to make a donation and help support this site and keep it advert free
|
Gloria
|
Posted - 11/12/2007 : 16:46
I get a message when I post a reply, it doesn't give me much time to read it. BUT, I think we have had it before. I will see if it does it when I post this. The answer to that was nooooo.
Edited by - Gloria on 11/12/2007 4:47:37 PM
I'd be dangerous with a brain!!!!! www.briercliffesociety.co.uk |
Stanley
Local Historian & Old Fart
36804 Posts
|
|
Posted - 11/12/2007 : 17:35
Some of my posts go in all right but on the way they report 'a transport error. Too quick to copy and it seems to work OK anyway. Site is a lot faster than of late. You are evidently getting there Doc. Thanks.
Stanley Challenger Graham
Barlick View stanley at barnoldswick.freeserve.co.uk |
Doc
Keeper of the Scrolls
2010 Posts
|
|
Posted - 11/12/2007 : 17:50
The transport error that you are getting is because I have had to turn the email off. When you post a reply to a topic that other members have subscribed to, the software attempts to notify them by email, because it's turned off it generates that message.
Nothing to worry about, I'm working on the email side as we speak
TTFN - Doc
Due to the current economic climate, the light at the end of the tunnel has now been switched off. Click here to make a donation and help support this site and keep it advert free
|
Stanley
Local Historian & Old Fart
36804 Posts
|
|
Posted - 12/12/2007 : 06:00
I wasn't worrying...... Just standing back awestruck......
Stanley Challenger Graham
Barlick View stanley at barnoldswick.freeserve.co.uk |
Stanley
Local Historian & Old Fart
36804 Posts
|
|
Posted - 12/12/2007 : 06:04
PS. The speed of the site is getting better all the time. I should say it's faster now than it has ever been. Is this SQL beginning to have an effect as it indexes?
Stanley Challenger Graham
Barlick View stanley at barnoldswick.freeserve.co.uk |