Re: Opinions on a good choice for application re-write
- From: "toby" <toby@xxxxxxxxxxxxxxxxxxx>
- Date: 28 Mar 2006 18:54:19 -0800
ArkGunSlingler wrote:
"Daniel T." <postmaster@xxxxxxxxxxx> wrote in message
news:postmaster-B4C8E1.16485628032006@xxxxxxxxxxxxxxxxxxx
In article <1143566523.269838.65810@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
pratclif@xxxxxxxxxxxxxxxx wrote:
Hello All,
I'd love to hear some informed opinions about chosing a programming
language. I'm a DBA, not a programmer (my programming experience is C
and C++ in the classroom) but my company has a VB6 application which
front-ends a SQL Server 2000 db and they want to rewrite this as a
browser-based application.
The db is not large but is fairly complex. The application is in-house
only with less than 500 users but is an essential app.
What are the thoughts on which language/concept (C++? .net? C#? Java?)
would be a good choice and why? While I am (or was at one time)
familiar with C, C++ & assembly, I am ignorant of most of these newer
options - so be *basic* with your answers.
A friend works at a company that did something like the above in VB.
They are having real problems competing with other companies who's
products run much faster... Other than that, I know nothing.
His boss told me, if they had it to do over again, they would write it
in Python and use C++ in places where speed is an issue.
I doubt VB was the real reason causing speed issues. Typically speed issues
with database applications are usually due to ineffective db programming i.e
failure to
use stored procedures, poorly designed table relations(normalization vs
Speed optimation),
poorly written queries, using the wrong type of cursor and a host of other
things.
If database best practices aren't followed it won't make any difference what
you use on the front end.
Agree.
I worked on a team effort VB6/MSSQL2000 DB application that are stores over
20,000
floating point values every 20 seconds
I first read that as '20,000 floating point viruses', honest.
and that's just part of the data.
The app is being used by hundreds of sites around the world.
Here's a link to some performance tips for MSSQL
Hmm... if you're going to reconsider the language, maybe you can
reconsider the database. Here are some very interesting case studies
for MySQL, including several sites doing 2,000+ transactions per second
(e.g. the first listed), and others doing even more:
http://www.mysql.com/why-mysql/case-studies/
MySQL users include Sony, craigslist, Dell, Friendster, Citysearch, Los
Alamos, AP, US Census Bureau as well as the better known users such as
IMDB, Slashdot and Wikipedia...
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
I'm sure there are others out there also.
I'd reccommend that you post your question over in a MSSQL specific group
such as
microsoft.public.sqlserver.programming
No way I'm going to get into the Dot Net vs Python vs Java vs someone's
favorite
Dev tool fray!
There are plenty of *pragmatic* reasons for not choosing C++ or Java
for something like this.
With limited programming experience you do have a change in front of you
so good luck and keep us posted.
AGS
.
- References:
- Opinions on a good choice for application re-write
- From: pratclif
- Re: Opinions on a good choice for application re-write
- From: Daniel T.
- Re: Opinions on a good choice for application re-write
- From: ArkGunSlingler
- Opinions on a good choice for application re-write
- Prev by Date: Re: Opinions on a good choice for application re-write
- Next by Date: Patricia Tree
- Previous by thread: Re: Opinions on a good choice for application re-write
- Next by thread: Re: Opinions on a good choice for application re-write
- Index(es):
Relevant Pages
|
