Some guidance is requested.
I will be developing an application in C#.NET.
This app will require a db, the organization size is approx 50 users,
all of which all part time users, maybe 10% users.
I know I can use MSDE which will handle 5 users without licensing
costs. Or use MSACCESS.
BUT
It is tempting to use one of the open source databases such as
firebird (interbase, borland) or mysql.
Question is should I say in the MS family when programming with C#
(and the visual studio .NET IDE) or is it relatively painless to use
an opensource?
I am using .NET for the productivity. I do not want to give up my
drag and drop to save a few hundred $. I do not want to incur a lot
of additional hand coding to use an open source db.
Question: Stay in the MS family or use an open source without much
pain and little additional coding?
Thanks 10 2143
So you would/are recommend/ing?
MSSqlServer?
Development on MSDE on the desktop and migrate to MSSqlServer?
thanks
"q@q.com" <q@q.com> wrote in message news:<40**************@q.com>... MSAccess is not recommended for medium to high number of connections.
MSDE is NOT recommended for more than 5 concurrent connections. Jet is NOT recommended for more than 20 connections.
MySQL does not support stored procedures. At least not until 5.0 is released.
Bob wrote:
Some guidance is requested.
I will be developing an application in C#.NET. This app will require a db, the organization size is approx 50 users, all of which all part time users, maybe 10% users.
I know I can use MSDE which will handle 5 users without licensing costs. Or use MSACCESS.
BUT
It is tempting to use one of the open source databases such as firebird (interbase, borland) or mysql.
Question is should I say in the MS family when programming with C# (and the visual studio .NET IDE) or is it relatively painless to use an opensource?
I am using .NET for the productivity. I do not want to give up my drag and drop to save a few hundred $. I do not want to incur a lot of additional hand coding to use an open source db.
Question: Stay in the MS family or use an open source without much pain and little additional coding?
Thanks
No matter which way you go, I strongly recommend you avoid using the wizards
and the drag and drop features. yes, they are quicker, but in the end, much
harder to maintain or to write generic all purpose code with.
I would stay with MS, just because it will be much easier to get support and
find answers when using common technology. A lot more people are using MSDE
and Access, then any of the open source database you mentioned.
"Bob" <cl****@qualitythink.com> wrote in message
news:cf**************************@posting.google.c om... Some guidance is requested.
I will be developing an application in C#.NET. This app will require a db, the organization size is approx 50 users, all of which all part time users, maybe 10% users.
I know I can use MSDE which will handle 5 users without licensing costs. Or use MSACCESS.
BUT
It is tempting to use one of the open source databases such as firebird (interbase, borland) or mysql.
Question is should I say in the MS family when programming with C# (and the visual studio .NET IDE) or is it relatively painless to use an opensource?
I am using .NET for the productivity. I do not want to give up my drag and drop to save a few hundred $. I do not want to incur a lot of additional hand coding to use an open source db.
Question: Stay in the MS family or use an open source without much pain and little additional coding?
Thanks
IMHO, Access provides a single benefit: portability. Because it is a file
type database, it can easily be deployed and transported regardless of what
is on the server. However, it has significant downsides that have nothing
to do with concurrency levels. For one, the Jet engine processing is
dependent on the client side machine. That means if some of your clients do
not have the latest Jet patch, they may get odd or incorrect results from
other users. Another downside to Access is that the SQL syntax is slightly
different. Another reason is that Access databases can corrupt. When it
corrupts, everyone must exit the database so that it can be repaired.
Another reason is that everyone must exit the db in order to properly backup
the db.
If you know that you can install something on the server, then I would go
with MSDE and let the performance levels dictate whether you should upgrade
to a full copy of SQL Server.
I would not make it my plan to develop your system with the idea of upgrade
from Access to SQL. It would be much easier to assume a SQL Server-like db
from the start so that you can benefit from stored procedures and such.
HTH,
Tom
"Bob" <cl****@qualitythink.com> wrote in message
news:cf**************************@posting.google.c om... So you would/are recommend/ing?
MSSqlServer?
Development on MSDE on the desktop and migrate to MSSqlServer?
thanks
"q@q.com" <q@q.com> wrote in message news:<40**************@q.com>... MSAccess is not recommended for medium to high number of connections.
MSDE is NOT recommended for more than 5 concurrent connections. Jet is NOT recommended for more than 20 connections.
MySQL does not support stored procedures. At least not until 5.0 is released.
Bob wrote:
Some guidance is requested.
I will be developing an application in C#.NET. This app will require a db, the organization size is approx 50 users, all of which all part time users, maybe 10% users.
I know I can use MSDE which will handle 5 users without licensing costs. Or use MSACCESS.
BUT
It is tempting to use one of the open source databases such as firebird (interbase, borland) or mysql.
Question is should I say in the MS family when programming with C# (and the visual studio .NET IDE) or is it relatively painless to use an opensource?
I am using .NET for the productivity. I do not want to give up my drag and drop to save a few hundred $. I do not want to incur a lot of additional hand coding to use an open source db.
Question: Stay in the MS family or use an open source without much pain and little additional coding?
Thanks
MSAccess is not recommended for medium to high number of connections.
MSDE is NOT recommended for more than 5 concurrent connections.
Jet is NOT recommended for more than 20 connections.
MySQL does not support stored procedures.
At least not until 5.0 is released.
Bob wrote: Some guidance is requested.
I will be developing an application in C#.NET. This app will require a db, the organization size is approx 50 users, all of which all part time users, maybe 10% users.
I know I can use MSDE which will handle 5 users without licensing costs. Or use MSACCESS.
BUT
It is tempting to use one of the open source databases such as firebird (interbase, borland) or mysql.
Question is should I say in the MS family when programming with C# (and the visual studio .NET IDE) or is it relatively painless to use an opensource?
I am using .NET for the productivity. I do not want to give up my drag and drop to save a few hundred $. I do not want to incur a lot of additional hand coding to use an open source db.
Question: Stay in the MS family or use an open source without much pain and little additional coding?
Thanks
Bob
Don't be fooled by the 5 concurrent connection restrictions with MSDE. If you write your app properly, as a disconnected system (open connection, do processing, close connection) with connectiong pooling, you can effectively support many more users than 5. Most of the time a user spends in an application is *usually* data entry. Only a small portion of time is spent connected to a db.
My recommendation would be to use MSDE, and upgrade to MSSQL if you find the system size/usage starts growing too much.
Cheers cl****@qualitythink.com (Bob) wrote in news:cfa521f2.0404070653.10858fa2
@posting.google.com: I will be developing an application in C#.NET. This app will require a db, the organization size is approx 50 users, all of which all part time users, maybe 10% users.
I know I can use MSDE which will handle 5 users without licensing costs. Or use MSACCESS.
MSDE handles 5 concurrent connections at a time OR 5 T-SQL
statements at a time. The 6th is queued. If your app is well written (that
is, does open a connection only when it needs to and closes it right after
that) you can have on average 30 to 40 users on an MSDE database without
slowdowns, because not everyone is hammering the database all the time.
This also depends on the nature of your application of course.
It is tempting to use one of the open source databases such as firebird (interbase, borland) or mysql.
Question is should I say in the MS family when programming with C# (and the visual studio .NET IDE) or is it relatively painless to use an opensource?
I am using .NET for the productivity. I do not want to give up my drag and drop to save a few hundred $. I do not want to incur a lot of additional hand coding to use an open source db.
Question: Stay in the MS family or use an open source without much pain and little additional coding?
Firebird is very good, mature and its provider is very solid. I
find Firebird very fast and it's easy to setup and with IB Expert personal
edition (free) you have a great tool to administrate it.
You can't drag-drop stuff in a gui, so if that's what you want,
stick with MSDE and SqlServer.
FB
--
Get LLBLGen Pro, the new O/R mapper for .NET: http://www.llblgen.com
My .NET Blog: http://weblogs.asp.net/fbouma
Microsoft C# MVP
So you would/are recommend/ing?
MSSqlServer?
Development on MSDE on the desktop and migrate to MSSqlServer?
thanks
"q@q.com" <q@q.com> wrote in message news:<40**************@q.com>... MSAccess is not recommended for medium to high number of connections.
MSDE is NOT recommended for more than 5 concurrent connections. Jet is NOT recommended for more than 20 connections.
MySQL does not support stored procedures. At least not until 5.0 is released.
Bob wrote:
Some guidance is requested.
I will be developing an application in C#.NET. This app will require a db, the organization size is approx 50 users, all of which all part time users, maybe 10% users.
I know I can use MSDE which will handle 5 users without licensing costs. Or use MSACCESS.
BUT
It is tempting to use one of the open source databases such as firebird (interbase, borland) or mysql.
Question is should I say in the MS family when programming with C# (and the visual studio .NET IDE) or is it relatively painless to use an opensource?
I am using .NET for the productivity. I do not want to give up my drag and drop to save a few hundred $. I do not want to incur a lot of additional hand coding to use an open source db.
Question: Stay in the MS family or use an open source without much pain and little additional coding?
Thanks
IMHO, Access provides a single benefit: portability. Because it is a file
type database, it can easily be deployed and transported regardless of what
is on the server. However, it has significant downsides that have nothing
to do with concurrency levels. For one, the Jet engine processing is
dependent on the client side machine. That means if some of your clients do
not have the latest Jet patch, they may get odd or incorrect results from
other users. Another downside to Access is that the SQL syntax is slightly
different. Another reason is that Access databases can corrupt. When it
corrupts, everyone must exit the database so that it can be repaired.
Another reason is that everyone must exit the db in order to properly backup
the db.
If you know that you can install something on the server, then I would go
with MSDE and let the performance levels dictate whether you should upgrade
to a full copy of SQL Server.
I would not make it my plan to develop your system with the idea of upgrade
from Access to SQL. It would be much easier to assume a SQL Server-like db
from the start so that you can benefit from stored procedures and such.
HTH,
Tom
"Bob" <cl****@qualitythink.com> wrote in message
news:cf**************************@posting.google.c om... So you would/are recommend/ing?
MSSqlServer?
Development on MSDE on the desktop and migrate to MSSqlServer?
thanks
"q@q.com" <q@q.com> wrote in message news:<40**************@q.com>... MSAccess is not recommended for medium to high number of connections.
MSDE is NOT recommended for more than 5 concurrent connections. Jet is NOT recommended for more than 20 connections.
MySQL does not support stored procedures. At least not until 5.0 is released.
Bob wrote:
Some guidance is requested.
I will be developing an application in C#.NET. This app will require a db, the organization size is approx 50 users, all of which all part time users, maybe 10% users.
I know I can use MSDE which will handle 5 users without licensing costs. Or use MSACCESS.
BUT
It is tempting to use one of the open source databases such as firebird (interbase, borland) or mysql.
Question is should I say in the MS family when programming with C# (and the visual studio .NET IDE) or is it relatively painless to use an opensource?
I am using .NET for the productivity. I do not want to give up my drag and drop to save a few hundred $. I do not want to incur a lot of additional hand coding to use an open source db.
Question: Stay in the MS family or use an open source without much pain and little additional coding?
Thanks
Bob
Don't be fooled by the 5 concurrent connection restrictions with MSDE. If you write your app properly, as a disconnected system (open connection, do processing, close connection) with connectiong pooling, you can effectively support many more users than 5. Most of the time a user spends in an application is *usually* data entry. Only a small portion of time is spent connected to a db.
My recommendation would be to use MSDE, and upgrade to MSSQL if you find the system size/usage starts growing too much.
Cheers cl****@qualitythink.com (Bob) wrote in news:cfa521f2.0404070653.10858fa2
@posting.google.com: I will be developing an application in C#.NET. This app will require a db, the organization size is approx 50 users, all of which all part time users, maybe 10% users.
I know I can use MSDE which will handle 5 users without licensing costs. Or use MSACCESS.
MSDE handles 5 concurrent connections at a time OR 5 T-SQL
statements at a time. The 6th is queued. If your app is well written (that
is, does open a connection only when it needs to and closes it right after
that) you can have on average 30 to 40 users on an MSDE database without
slowdowns, because not everyone is hammering the database all the time.
This also depends on the nature of your application of course.
It is tempting to use one of the open source databases such as firebird (interbase, borland) or mysql.
Question is should I say in the MS family when programming with C# (and the visual studio .NET IDE) or is it relatively painless to use an opensource?
I am using .NET for the productivity. I do not want to give up my drag and drop to save a few hundred $. I do not want to incur a lot of additional hand coding to use an open source db.
Question: Stay in the MS family or use an open source without much pain and little additional coding?
Firebird is very good, mature and its provider is very solid. I
find Firebird very fast and it's easy to setup and with IB Expert personal
edition (free) you have a great tool to administrate it.
You can't drag-drop stuff in a gui, so if that's what you want,
stick with MSDE and SqlServer.
FB
--
Get LLBLGen Pro, the new O/R mapper for .NET: http://www.llblgen.com
My .NET Blog: http://weblogs.asp.net/fbouma
Microsoft C# MVP This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: thecrow |
last post by:
Alright, what the hell is going on here?
In the following code, I expect the printed result to be:
DEBUG: frank's last name is burns.
Instead, what I get is:
DEBUG: frank's last name is...
|
by: Brandon J. Van Every |
last post by:
What's better about Ruby than Python? I'm sure there's something. What is
it?
This is not a troll. I'm language shopping and I want people's answers. I
don't know beans about Ruby or have...
|
by: mike420 |
last post by:
I think everyone who used Python will agree that its syntax is
the best thing going for it. It is very readable and easy
for everyone to learn. But, Python does not a have very good
macro...
|
by: Reed L. O'Brien |
last post by:
I see rotor was removed for 2.4 and the docs say use an AES module
provided separately... Is there a standard module that works alike or
an AES module that works alike but with better encryption?...
|
by: Philippe C. Martin |
last post by:
I apologize in advance for launching this post but I might get enlightment
somehow (PS: I am _very_ agnostic ;-).
- 1) I do not consider my intelligence/education above average
- 2) I am very...
|
by: Dario |
last post by:
The following simple program behaves differently
in Windows and Linux .
#include <stdexcept>
#include <iostream>
#include <string>
using namespace std;
class LogicError : public logic_error {...
|
by: Sarah Tanembaum |
last post by:
Beside its an opensource and supported by community, what's the fundamental
differences between PostgreSQL and those high-price commercial database (and
some are bloated such as Oracle) from...
|
by: Neal |
last post by:
Patrick Griffiths weighs in on the CSS vs table layout debate in his blog
entry "Tables my ass" - http://www.htmldog.com/ptg/archives/000049.php . A
quite good article.
|
by: typingcat |
last post by:
First of all, I'm an Asian and I need to input Japanese, Korean and so
on. I've tried many PHP IDEs today, but almost non of them supported
Unicode (UTF-8) file.
I've found that the only Unicode...
|
by: Midnight Java Junkie |
last post by:
Dear Colleagues:
I feel that the dumbest questions are those that are never asked. I have
been given the opportunity to get into .NET. Our organization has a
subscription with Microsoft that...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |