Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Oracle - would you use it?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Oracle - would you use it?

 Post Reply Post Reply Page  <12
Author
JodoHost View Drop Down
Groupie
Groupie


Joined: 20 October 2003
Status: Offline
Points: 10
Post Options Post Options   Thanks (0) Thanks(0)   Quote JodoHost Quote  Post ReplyReply Direct Link To This Post Posted: 28 September 2004 at 8:33pm

Originally posted by michael michael wrote:

SQL Server is a good database but I never ever would use it on a shared hosting plan. Oracle shines in having big databases and will not really give you a huge benefit on some lousy 150MB database. On top of that without having more access to Oracle so you can deply your J2EE developed procedures etc. it would not make much more sense. Lastly, if you staff has little or no experience, let it go, it can become a nightmare to support if you do not know the product very well.

I am not referring to the benfits. Definately, there are no major benefits of Oracle over SQL Server for smaller websites and forums. Same way there are no major benefits of SQL Server over MySQL for personal sites (even though SQL Server is much more powerful).

My main question is that if Oracle was available at low prices, would it encourage you to use or experiment with it. We have Oracle DBAs and I never said we plan to introduce it :) Just a question

Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 29 September 2004 at 3:26am

I run oracle locally, but it's more just to keep my hand in PL/SQL and test out some features. I work with corporates who use it though, so need to keep up to speed.

IMHO, some versions of it haven't had good performance with smaller data bases - other versions optimized well for small db's. Seems to vary from release to release. I have used it for large web db's and have been pleased with the performance and some of the oo features.

Michael's point about shared hosting is a good one though. There's a different set of issues around db's in a shared hosting environment than what are faced with dedicated servers. The body of knowledge that constitutes best practices for Oracle shared hosting isn't as widely known as that for other DB's.


Lead me not into temptation... I know the short cut, follow me.
Back to Top
Gullanian View Drop Down
Senior Member
Senior Member
Avatar

Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373
Post Options Post Options   Thanks (0) Thanks(0)   Quote Gullanian Quote  Post ReplyReply Direct Link To This Post Posted: 29 September 2004 at 3:45am
No I wouldn't use it, SQL Server is 100% fine for what I develop.
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 29 September 2004 at 2:56pm
ive never touched it, i think i would stick with MSSQL server if i had the choice.
Back to Top
theSCIENTIST View Drop Down
Senior Member
Senior Member


Joined: 31 July 2003
Location: United Kingdom
Status: Offline
Points: 440
Post Options Post Options   Thanks (0) Thanks(0)   Quote theSCIENTIST Quote  Post ReplyReply Direct Link To This Post Posted: 03 October 2004 at 6:51pm
If Oracle was available at low prices (in conjuction with MSSQL on the same package), I would definitely go for it just to play with it a bit out of curiosity, I would also run tests btw Oracle and MSSQL just to see how they difer, even thou I never touched the stuff before.

If you have Oracle DBA's at close range, I think it would add value and features to your service.

My own server has MSSQL and MySQL that I use alot and btw them all my DB needs are met, however, if I could get my hands on Oracle and a DBA or two I would go for it, at least for six months trialing it to measure acceptance and other issues.
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.