Visit the historic Lancashire Textile Project with over 500 photos and 190 taped interviews|2|0
Previous Page    1  2  [3]  4  5   Next Page
Author Previous Topic Topic Next 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 Confused


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
Previous Page    1  2  [3]  4  5   Next Page
 
Big Kev
Big


2650 Posts
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. Go to Top of Page
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 

  Go to Top of Page
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 Go to Top of Page
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 Go to Top of Page
Stanley
Local Historian & Old Fart


36804 Posts
Posted - 13/12/2007 : 09:37
Found this one this morning......

Briercliffes of Burwains - Family Microsoft VBScript runtime error '800a0009' Subscript out of range: '[number: 1]'

/inc_functions.asp, line 2790



Stanley Challenger Graham




Barlick View
stanley at barnoldswick.freeserve.co.uk Go to Top of Page
melteaser
Genealogist


4819 Posts
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 Go to Top of Page
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 

  Go to Top of Page
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 Go to Top of Page
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 Go to Top of Page
belle
VIP Member


6502 Posts
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 itGo to Top of Page
Doc
Keeper of the Scrolls


2010 Posts
Posted - 15/12/2007 : 13:03
Belle, sometimes I feel like doing one Kill-it


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 

  Go to Top of Page
melteaser
Genealogist


4819 Posts
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 Go to Top of Page
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 Cheers


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 

  Go to Top of Page
moh
Silver Surfer


6860 Posts
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 Go to Top of Page
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 

  Go to Top of Page
Topic is 5 Pages Long:
Previous Page    1  2  [3]  4  5   Next Page
 


Set us as your default homepage Bookmark us Privacy   Copyright © 2004-2011 www.oneguyfrombarlick.co.uk All Rights Reserved. Design by: Frost SkyPortal.net Go To Top Of Page

Page load time - 0.500