| 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 |
|
|
panbiker
|
Posted - 11/12/2007 : 00:52
Hi Doc,
Get this error message when updating any of the score tables in Arcade. Good job I did'nt have any decent scores!
Microsoft OLE DB Provider for SQL Server error '80040e14' 'val' is not a recognized function name.
/modules/arcade/arcade_functions.asp, line 845
Ian  |
panbiker
|
Posted - 11/12/2007 : 00:55
And this one when a page I tried to load timed out
Microsoft OLE DB Provider for SQL Server error '80040e31'
Timeout expired
/forum_topic.asp, line 276
Ian |
Doc
Keeper of the Scrolls
2010 Posts
|
|
Posted - 11/12/2007 : 00:56
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.
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 : 01:10
Sorted the arcade error out. the timeout is because the system is under load at the moment, I'm rebuilding all the indexes while its quite.
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
|
panbiker
|
Posted - 11/12/2007 : 01:25
Once it's stable it will be a major enhancement, we use SQL on the admin side at school, the auto indexing and rollback can be a godsend.
Ian |
Another
Traycle Mine Overseer
6250 Posts
|
|
Posted - 11/12/2007 : 06:36
Good news Doc. Thanks for keeping us all in the picture. Nolic
" I'm a self made man who worships his creator"  |
Stanley
Local Historian & Old Fart
36804 Posts
|
|
Posted - 11/12/2007 : 08:28
A good thing to let the members know what's going on Doc. They will tolerate the glytches and report them. Thanks for all the work I know you are putting in. Tell them about the SMTP server attack as well. Most members don't realise how much you are doing for us.
Stanley Challenger Graham
Barlick View
stanley at barnoldswick.freeserve.co.uk |
Stanley
Local Historian & Old Fart
36804 Posts
|
|
Posted - 11/12/2007 : 08:46
Active Server Pages error 'ASP 0113' Script timed out /forum_post_info.asp
Got this while posting on Hardacre topic...... just like the old days! Went back and though slow, it loaded.
Stanley Challenger Graham
Barlick View
stanley at barnoldswick.freeserve.co.uk |
Gloria
|
Posted - 11/12/2007 : 08:46
I am sure all the members really do appreciate what you do for them Doc, even if they don't realise just how much it is that you do. 
I'd be dangerous with a brain!!!!!
www.briercliffesociety.co.uk |
Ringo
Site Administrator
3793 Posts
|
|
Posted - 11/12/2007 : 09:45
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/SkyBlog.asp, line 539
Got this when trying to read a blog
|
Stanley
Local Historian & Old Fart
36804 Posts
|
|
Posted - 11/12/2007 : 09:58
PMs are working again........
Stanley Challenger Graham
Barlick View
stanley at barnoldswick.freeserve.co.uk |
Stanley
Local Historian & Old Fart
36804 Posts
|
|
Posted - 11/12/2007 : 10:02
I got this when trying to open a full size image from the map I posted this morning.
Server Error in '/' Application.
A Graphics object cannot be created from an image that has an indexed pixel format. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Stanley Challenger Graham
Barlick View
stanley at barnoldswick.freeserve.co.uk |
Stanley
Local Historian & Old Fart
36804 Posts
|
|
Posted - 11/12/2007 : 10:04
I got this when trying to open a full size image from the map I posted this morning.
Server Error in '/' Application.
A Graphics object cannot be created from an image that has an indexed pixel format. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Stanley Challenger Graham
Barlick View
stanley at barnoldswick.freeserve.co.uk |
Stanley
Local Historian & Old Fart
36804 Posts
|
|
Posted - 11/12/2007 : 10:05
Got this while posting the above reply. It posted anyway but the page froze and I had to refresh to get back in.
New Reply Posted!
Database Error!
-2147217871 | Timeout expired
UPDATE PORTAL_MEMBERS SET M_LASTPOSTDATE = '20071211100241' WHERE M_NAME = 'Stanley'
Stanley Challenger Graham
Barlick View
stanley at barnoldswick.freeserve.co.uk |
Stanley
Local Historian & Old Fart
36804 Posts
|
|
Posted - 11/12/2007 : 10:06
You must be fed up with these error massages.... Courage Mon Brave!
Stanley Challenger Graham
Barlick View
stanley at barnoldswick.freeserve.co.uk |
Database Upgrade
