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 |
|
|
Big Kev
|
Posted - 12/12/2007 : 07:28
Like greasy lightning this morning. Nice one Doc........
Big Kev
It doesn't matter who you vote for, you always end up with the government. |
Doc
Keeper of the Scrolls
2010 Posts
|
|
Posted - 12/12/2007 : 09:15
With regards to the speed, everything is starting to settle down now and behave itself, I continue to fine tune the database and it seems to be paying off, a laborious task - 1 tweak then wait a few hours to see what happens , then another etc. I am getting to the stage where I am happy with its performance and will leave it alone.
Today I have to rewrite the "Search Routines" to take advantage of the new indexes, the existing search scans the entire database for the search query while the new search will more or less go directly to the result. I'll see what happens later when I write it.
All the bugs seemed to have been resolved, I have only the email to get sorted but thats mentioned in another topic which I am about to go and read because big Kev has made a post, hopefully with some good news.
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 : 15:44
"All the bugs seemed to have been resolved," You're going to regret saying that........
Stanley Challenger Graham
Barlick View stanley at barnoldswick.freeserve.co.uk |
Stanley
Local Historian & Old Fart
36804 Posts
|
|
Posted - 12/12/2007 : 15:54
Doc told me he had finished the ugrade on the search engine so I tried it. It's wonderful, so fast you wouldn't believe it. Try it out for yourselfs, biggest single improvement yet. Thanks Doc........
Stanley Challenger Graham
Barlick View stanley at barnoldswick.freeserve.co.uk |
Stanley
Local Historian & Old Fart
36804 Posts
|
|
Posted - 13/12/2007 : 09:37
Found this one this morning......
Stanley Challenger Graham
Barlick View stanley at barnoldswick.freeserve.co.uk |
melteaser
|
Posted - 14/12/2007 : 21:03
Accidentally clicked on something in the links dropdown menu and got this - Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/modules/classifieds/classified_functions.asp, line 474 strSQL = "select * from CLASSIFIED where CONTAINS(KEYWORD,'""" & search & """') or CONTAINS(DESCRIPTION,'""" & search & """') or CONTAINS(TITLE,'""" & search & """') and show=1 order by HITS DESC, CLASSIFIED_ID DESC
Mel
http://www.briercliffesociety.co.uk |
Doc
Keeper of the Scrolls
2010 Posts
|
|
Posted - 14/12/2007 : 22:16
thanks Mel I've sorted that one now
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 - 15/12/2007 : 07:26
I had one at the top of a post as it was accepted for upload and I couldn't copy it. All i noted was that it ended with an email address for a Ruth Taylor.........
Stanley Challenger Graham
Barlick View stanley at barnoldswick.freeserve.co.uk |
Stanley
Local Historian & Old Fart
36804 Posts
|
|
Posted - 15/12/2007 : 07:39
Same again this morning and I think on the same topic, Hardacre. This time it was repeated three times and the email address was julie@hackandslash?
Stanley Challenger Graham
Barlick View stanley at barnoldswick.freeserve.co.uk |
belle
|
Posted - 15/12/2007 : 10:10
Doc, have a little chuckle at this, with all the recent contratemps about the upgrade on other topics, i mistakenly read this topic as Database uprising!
Life is what you make it |
Doc
Keeper of the Scrolls
2010 Posts
|
|
Posted - 15/12/2007 : 13:03
Belle, sometimes I feel like doing one
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 - 21/12/2007 : 18:04
Played Blix and this error was on the bottom of the scoreboard when my game ended ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/arcade.asp, line 0
Mel
http://www.briercliffesociety.co.uk |
Doc
Keeper of the Scrolls
2010 Posts
|
|
Posted - 21/12/2007 : 19:05
Thanks Mel, I'll sort it tomorrow - I'm Off to the party now
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
|
moh
|
Posted - 24/12/2007 : 12:49
Why is my home page so big? The rest are OK
Say only a little but say it well |
Doc
Keeper of the Scrolls
2010 Posts
|
|
Posted - 24/12/2007 : 17:05
Moh, it's an issue I'm trying to resolve, it might have to wait till after Xmas
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
|