| 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 |
|
|
Stanley
Local Historian & Old Fart
36804 Posts
|
|
Posted - 17/05/2011 : 05:57
Sorry Gamer, Pluggy is right. Someone has to keep whispering in his ear.....
EARTH TO DOC! ARE YOU RECEIVING!
Stanley Challenger Graham
Barlick View
stanley at barnoldswick.freeserve.co.uk  |
gamer
New Member
47 Posts
|
|
Posted - 17/05/2011 : 13:20
Well He helped me one time before when i was having a problem with the Arcade news not working on my front page, turns out it was some java scripting i had in my footer, any way he has his hands full having a life and keeping this site running smooth, i really like what i see here, i see lots of his coding work all over the site and i know it did not come the way i see it so i know he has done a lot of extra work here.
i would not rush him for nothing in the world, i still have some coding that has to be done and some that i will need help with, the only problem i see is finding the people out there that has the same things i have and hope they will help.
quote:
Stanley wrote:
Sorry Gamer, Pluggy is right. Someone has to keep whispering in his ear.....
EARTH TO DOC! ARE YOU RECEIVING!
 I seem to be just spinnin my wheels sometimes.
PoJ-IYD.com's World |
pluggy
|
Posted - 17/05/2011 : 16:33
There is a long term plan to abandon Skyportal and migrate the site to something a little more mainstream (I think Drupal was mentioned) which is what the 'friction' is about. Numerous long term problems with Macs and smartphones as well as the now defunct state of the portal software. We could get away with a smaller hosting package going to php as well.
Just so you know whats going on.
Need computer work ?
"http://www.stsr.co.uk" 
Pluggy's Household Monitor |
gamer
New Member
47 Posts
|
|
Posted - 17/05/2011 : 17:16
Yes i have tried Drupal and several others and i have used SP and MaxWeb
both started with MW and then went tp SP i have hade other sites running and just cant seem to find one that can or that i am will to use to replace my SP,
as most people that have SP they have invested time and money in to keeping there site going, i will do my best to keep my SP that i paid for and the Mod's that i paid for going as long as i can.
quote:
pluggy wrote:
There is a long term plan to abandon Skyportal and migrate the site to something a little more mainstream (I think Drupal was mentioned) which is what the 'friction' is about. Numerous long term problems with Macs and smartphones as well as the now defunct state of the portal software. We could get away with a smaller hosting package going to php as well.
Just so you know whats going on.
I seem to be just spinnin my wheels sometimes.
PoJ-IYD.com's World |
Stanley
Local Historian & Old Fart
36804 Posts
|
|
Posted - 18/05/2011 : 06:33
Just one small point, it isn't friction, just me performing my role as burr under the saddle. Doc understands that, we've talked about it many a time. I think he still likes me......
Stanley Challenger Graham
Barlick View
stanley at barnoldswick.freeserve.co.uk |
gamer
New Member
47 Posts
|
|
Posted - 18/05/2011 : 13:08
I think he still likes you.
quote:
Stanley wrote:
Just one small point, it isn't friction, just me performing my role as burr under the saddle. Doc understands that, we've talked about it many a time. I think he still likes me......
I seem to be just spinnin my wheels sometimes.
PoJ-IYD.com's World |
gamer
New Member
47 Posts
|
|
Posted - 18/05/2011 : 13:09
Ill make you a deal then when Doc finds something for here and is able to get all this massive data in a new type site i will try it also.
forgot to spell ck
Edited by - gamer on 18/05/2011 1:40:55 PM
I seem to be just spinnin my wheels sometimes.
PoJ-IYD.com's World |
Stanley
Local Historian & Old Fart
36804 Posts
|
|
Posted - 19/05/2011 : 05:54
The last time I spoke to Doc the most likely solution is the one other Drupal users have opted for which is to abandon trying to integrate the database in the new platform but put in a link to the archive. All the bot generated searches will still work. My view is that Doc is tryng to achieve perfection and he doesn't like to be beaten. I think there comes a point when the return of the investment of time isn't good enough. I favour the link solution and have told Doc that. But, it's his site and in the end he'll do what he thinks is best. All I can do is nag.......
Stanley Challenger Graham
Barlick View
stanley at barnoldswick.freeserve.co.uk |
gamer
New Member
47 Posts
|
|
Posted - 19/05/2011 : 17:57
Well my self i still love the way the SP software works, i don't have no where the content on my site.
But i would like to keep it the way i have it.
Also Just to give Doc and any one else an update i have gone live with the site on MSSQL.
I have sorted most of the bugs that i found before going live,
This is what i have been doing for the last week and a half, i know i have i bug and its the Arcade news not working on my front page, I had this problem before and it was a java script causing a clash in his code i guess.
Any way the site is running and all seems well for now, i would still like to here and maybe see the way Doc got past the code changes to get the Arcade working to see if my way is now causing the Arcade news not working on my front page,
Thanks for letting me share in this great place and i hope to continue to share and learn from here,
P.S Doc if you want me to post my fixes for the Arcade let me know, The VAL was just deleted and that was i am sure not the proper way, After resolving the MID issue deleting the VAL was it the Arcade is working, im off now to see if i can beet any scores and make sure it updates the counts. so Thanks again and ill post more later.
quote:
Stanley wrote:
All I can do is nag.......
I seem to be just spinnin my wheels sometimes.
PoJ-IYD.com's World |
gamer
New Member
47 Posts
|
|
Posted - 19/05/2011 : 20:09
Ok after testing more the fix i have is not going to be the way to go,
I will have to wait for Doc's Help i guess.
Just an update.
I seem to be just spinnin my wheels sometimes.
PoJ-IYD.com's World |
gamer
New Member
47 Posts
|
|
Posted - 23/05/2011 : 15:07
BUMP
Any word on helping me get my Arcade working with MSSQL ?
i have my site back up after hard drive went south, and also was wondering what version of MSSQL do you recomend ?
i have 2000 and 2008, i am having a problem getting MSSQL 2008 working now for some reason, as always i am sure it is something wrong (user error) any way i have MSSQL and Client ftpto install so clients can upload via FTP to there web Dir.
i have found something on Arcade but i will post it in the proper forum.
L8R all and i hope you all have a good day.
I seem to be just spinnin my wheels sometimes.
PoJ-IYD.com's World |
gamer
New Member
47 Posts
|
|
Posted - 25/05/2011 : 02:04
Ok just another update,
I have most of the code changed so Arcade is working and also showing
the High scores properly, if i run across any other issues i will post them here.
www.poj-iyd.com Check it out and let me know if there are any problems that you see, Also if i could get a volunteer to register on my site to insure registration is working proper,
Thanks
I will post my MID and VAL fix here also when i am sure it is resolved.
I seem to be just spinnin my wheels sometimes.
PoJ-IYD.com's World |
gamer
New Member
47 Posts
|
|
Posted - 31/05/2011 : 00:06
Bump
I seem to be just spinnin my wheels sometimes.
PoJ-IYD.com's World |
gamer
New Member
47 Posts
|
|
Posted - 31/05/2011 : 00:08
No volunteers ?
quote:
gamer wrote:
www.poj-iyd.com Check it out and let me know if there are any problems that you see, Also if i could get a volunteer to register on my site to insure registration is working proper,
Thanks
I seem to be just spinnin my wheels sometimes.
PoJ-IYD.com's World |
gamer
New Member
47 Posts
|
|
Posted - 03/07/2011 : 19:40
BUMP BUMP
Hey Doc i seem to be having an issue with the Hall Of Fame,
it does not seem to update, even before i ported over to MSSQL,
here is a screen shot,
any idea why this is not working ?
I seem to be just spinnin my wheels sometimes.
PoJ-IYD.com's World |
Database Upgrade
