| Author |
Topic Search Topic Options
|
theSCIENTIST
Senior Member
Joined: 31 July 2003
Location: United Kingdom
Status: Offline
Points: 440
|
Post Options
Thanks(0)
Quote Reply
Topic: Databases used Posted: 06 October 2004 at 12:41pm |
|
The application I'm building will be using WWF as the core, and I'm facing a difficult decision regarding the backend support.
I want it to reach a wide group of people but at the same time I'm inclined not to support MS Access at all (and remove all code related to it), and focus only on MSSQL, because I think that those that still use MS Access will sooner or later upgrade to MSSQL, I need to know your opinions on this matter, as supporting both backends will require a great deal of time, you know adding design to one and then the other is too much.
Please vote and be fair.
Thx.
|
|
|
 |
Gullanian
Senior Member
Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 October 2004 at 1:13pm |
|
If your attempting to market software, always make it as scalable as
possible. Don't make MS-SQL the only option, recommend it but
also support Access. The more you support, the wider your
audience. The code change between the two isn't much anyway most
likely.
|
 |
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 October 2004 at 1:50pm |
Gullanian wrote:
The code change between the two isn't much anyway most
likely.
|
Thats not always true, I often use quite complex stored procedures in
SQL Server and some of those could not be easily rewritting in access.
Well at least without making multiple queries
|
 |
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 October 2004 at 3:09pm |
|
Both of you are right, you need to know your audience. Looking at this forum there are plenty of "kids" that use free hosting and don't see the benefit of using sql server. if you use wwf as the core you might as well use both systems. the main problem is that you need to scale functions, or you will end up with two code sets, as some things are just not possible with access.
|
|
|
 |
theSCIENTIST
Senior Member
Joined: 31 July 2003
Location: United Kingdom
Status: Offline
Points: 440
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 October 2004 at 4:09pm |
|
That's the kind of thing I'm trying to avoind, having to develope scalable code to support both backends, that will take twice as long, not to mention having to debug and test both, I know some people still use Access, but the trend will be to move away from it sooner or later. On the other end, I could be doing a critical mistake by not supporting Access, since I want a wide audience, that's the purpose of starting this poll.
|
|
|
 |
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 October 2004 at 4:14pm |
|
I think it all depends on what is more important to this application.
performance (if you choose ONE database platform you will be able to
optimise it more for that platform) or extensibility which will
probably lead to a decrease in performance. It all depends on what the
application is
|
 |
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 October 2004 at 4:16pm |
|
Also, it depends who the application is aimed at. If it is high end
(i.e. aimed at corporate customers and needs to be very scalable) or
aimed at the lower end that want a quick and easy to use datasource but
are not too worried about scalability.
|
 |
theSCIENTIST
Senior Member
Joined: 31 July 2003
Location: United Kingdom
Status: Offline
Points: 440
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 October 2004 at 5:32pm |
|
So far, I'm inclined to drop Access altogether, I know this "kids" who use free hosting to have some fun, but even they will not be "kids" forever and they will not want to just have fun forever, there's going to be a time they start being a bit more serious and then they will move to a proper paid host with MSSQL..
Humm, I think I should focus on MSSQL, but let's run this poll for a few more days.
|
|
|
 |