Offer to help

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   As others have mentioned, I've been getting a lot of time-out errors when navigating around the forum. But I think I can help! I recognize the SQL OLE DB error, and perhaps I can offer some of my experience as a MS SQL Server programmer. I could create indexes and defragment the database on a schedule so that it will run queries faster, and perhaps transform some of the heavier queries into stored procedures. All of these could have a dramatic effect on the performance of the website. This might also make it possible to broaden the search function to include message content as well as topic titles without hindering performance.

Would the admins be interested in something like a trade of SQL work for ad space when my band's new CD comes out later this year?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
jplanet Members Profile Send Private Message Find Members Posts Add to Buddy List Reviewer page Forum Senior Member VIP Member Joined: August 30 2006 Location: NJ Status: Offline Points: 799	Topic: Offer to help Posted: August 04 2008 at 17:02
	As others have mentioned, I've been getting a lot of time-out errors when navigating around the forum. But I think I can help! I recognize the SQL OLE DB error, and perhaps I can offer some of my experience as a MS SQL Server programmer. I could create indexes and defragment the database on a schedule so that it will run queries faster, and perhaps transform some of the heavier queries into stored procedures. All of these could have a dramatic effect on the performance of the website. This might also make it possible to broaden the search function to include message content as well as topic titles without hindering performance. Would the admins be interested in something like a trade of SQL work for ad space when my band's new CD comes out later this year?
	..::welcome to the shadow circus::..

Easy Livin Members Profile Send Private Message Find Members Posts Add to Buddy List Reviewer page Special Collaborator Honorary Collaborator / Retired Admin Joined: February 21 2004 Location: Scotland Status: Offline Points: 15585	Posted: August 04 2008 at 17:18
	Cheers JP. It's M@x who looks after that side of things. I'll make sure he's aware of your kind offer.

jplanet Members Profile Send Private Message Find Members Posts Add to Buddy List Reviewer page Forum Senior Member VIP Member Joined: August 30 2006 Location: NJ Status: Offline Points: 799	Posted: August 05 2008 at 19:49
	Great, please keep me posted as I have a window of opportunity as far as having some free time, but I don't know how long that will last!...My CV and portfolio are also available for review at http://www.websiteandsound.com, in case M@x would like to review my SQL Server qualifications...
	..::welcome to the shadow circus::..