Click here to register on OneGuyFromBarlick|2|1
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
 
Doc
Keeper of the Scrolls


2010 Posts
Posted - 24/12/2007 : 21:17
If anyone noticed that the number of registered members is reduced then I am at fault, I apologise for deleting fifty of those most dedicated ex-Barlicker's that we had living in Afghanistan who graciously thought that out lives would be enlightened if we visited their salubrious websites that they had on offer.

Now about these Russian ex-Barlicker's... Smile


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
Ringo
Site Administrator


3793 Posts
Posted - 24/12/2007 : 21:31
I cant think of ant regular posters who are Russian......blitz em


Click for Skipton, United Kingdom Forecast
Go to Top of Page
Stanley
Local Historian & Old Fart


36804 Posts
Posted - 25/12/2007 : 04:58
You mean you've deleted Oscar Bin Liner? 

Thanks for all the work on the site Doc, it shows and it will pay off big time eventually.....


Stanley Challenger Graham




Barlick View
stanley at barnoldswick.freeserve.co.uk Go to Top of Page
Ringo
Site Administrator


3793 Posts
Posted - 26/12/2007 : 09:14
I have just deleted another two Afgan members, even though the things they were selling seemed reasonably priced


Click for Skipton, United Kingdom Forecast
Go to Top of Page
Stanley
Local Historian & Old Fart


36804 Posts
Posted - 27/12/2007 : 06:33
The home page is the right size when you open it up first time now. 


Stanley Challenger Graham




Barlick View
stanley at barnoldswick.freeserve.co.uk Go to Top of Page
Doc
Keeper of the Scrolls


2010 Posts
Posted - 27/12/2007 : 15:46
I sorted it last night


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
Ringo
Site Administrator


3793 Posts
Posted - 07/01/2008 : 11:04
The Afghan people still keep trying to register on the site but I am trying to keep on top of th matter and delete them.


Click for Skipton, United Kingdom Forecast
Go to Top of Page
gamer
New Member


47 Posts
Posted - 15/05/2011 : 12:44
Hey Doc if you don't mind how did you fix the errors of VAL and MID,
I am doing the same thing i am porting over to MSSQL and all is going well  except Arcade and News.
Thanks for any help here.

quote:
Doc wrote:
Thanks Ian, it's errors like that, that I need to catch, they work fine in MS Access but not in SQL.

I'll do the fix asap.




Gamer I seem to be just spinnin my wheels sometimes.                               

PoJ-IYD.com's World Go to Top of Page
Sunray10
Regular Member


557 Posts
Posted - 15/05/2011 : 14:00
Hi Doc, everything seems to be running well from my end, nothing un-toward to report, as yet.
Thumbs-up


R.Spencer. Go to Top of Page
Doc
Keeper of the Scrolls


2010 Posts
Posted - 15/05/2011 : 14:27
Gamer is another webmaster running the same software suite and is trying to convert over to Microsoft SQL from Access.

He is using the arcade module which I developed years ago, all I have to do is try to figure out which piece of code I changed 2-3 years ago to get it to run on SQL.

Time to delve into the few thousand lines of code that makes up the arcade module.

Watch this space.


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
gamer
New Member


47 Posts
Posted - 15/05/2011 : 14:51
Thank you for a quick responce, i want to keep my SkyPortal alive and going well.
if it would be easier to just pack up the files and email them or is that not a good way ?
either way thanks for your help. and i may be asking more questions as well, lol

quote:
Doc wrote:
Gamer is another webmaster running the same software suite and is trying to convert over to Microsoft SQL from Access.

He is using the arcade module which I developed years ago, all I have to do is try to figure out which piece of code I changed 2-3 years ago to get it to run on SQL.

Time to delve into the few thousand lines of code that makes up the arcade module.

Watch this space.




Gamer I seem to be just spinnin my wheels sometimes.                               

PoJ-IYD.com's World Go to Top of Page
Stanley
Local Historian & Old Fart


36804 Posts
Posted - 16/05/2011 : 05:39
New platform? I'm nagging aren't I......


Stanley Challenger Graham




Barlick View
stanley at barnoldswick.freeserve.co.uk Go to Top of Page
gamer
New Member


47 Posts
Posted - 16/05/2011 : 13:35
well kinda, but not realy, i have MYSQL and MSSQL and ACCESS sites running.
i just want to go ahead and get my main site over to MSSQL, running a backup is not
hard to do on a SP built site when it's on Access but one day Access will not handle to load,
and here latley i have had to restart my IIS a lot, i am hoping that when i get it all over MSSQL
some of that will stop,then running backup on a MSSQL database is not to hard seing i
own and run all my servers right here within walking distance, like 20 feet.
i have got a lot of the code fixed or corrected for this i still have a long road ahead of me.
the test site is a dup of my main site right now.
main site is www.poj-iyd.com now on MSSQL and the test site is sjbnet1.poj-iyd.com on MYSQL running Drupal.
quote:
Stanley wrote:
New platform? I'm nagging aren't I......


Edited by - gamer on 03/07/2011 14:17:58


Gamer I seem to be just spinnin my wheels sometimes.                               

PoJ-IYD.com's World Go to Top of Page
gamer
New Member


47 Posts
Posted - 16/05/2011 : 13:36
And no you are not nagging,

quote:
Stanley wrote:
New platform? I'm nagging aren't I......




Gamer I seem to be just spinnin my wheels sometimes.                               

PoJ-IYD.com's World Go to Top of Page
pluggy
Geek


1164 Posts
Posted - 16/05/2011 : 14:37
I think it may be Doc he's nagging.

 Long story..........


Need computer work ?
"http://www.stsr.co.uk"

Pluggy's Household Monitor 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