What client programming language you use is irrelevant in this case. So is
your domain controller. What is relevant is the nature of the database app
itself (i.e. your queries, stored procedures, and so on). Generally speaking,
64 bit is definitely the industry trend and the way to go in abstarct. But at
this particular point in time, some apps can still run faster on 32 bit than
on 64 bit. And even among these apps, one should question whether the extent
to which an app is faster on 32 bit is significant enough in comparison with
the growth potential of the 64-bit platform. But some apps may just care
about that performance difference.
All I wanted to point out was that people should not blindly assume that
going to 64 bit is always a win. This may appear to be a trivial argument and
stating the obvious. But if you are not careful, that's precisely the
impression you may walk away with when you go to some of the seminars out
there.
Linchi
[quoted text, click to view] "bijupg@hotmail.com" wrote:
> My applications are Visual basic 6.0 desktop APPLICATIONS For databases
> interactions and asp.net browser based applications .
> what about doamin controllers shold i have 64 bit domain controller or 32
> bit OK.
> web server 64 bit or 32 bit?
> Pls advice
>
> "Linchi Shea" wrote:
>
> > Without knowing the nature of your app, nobody can be certain which (32 bit
> > vs 64 bit) will come out with better performance. I suggest testing your app
> > on both platforms to be sure.
> >
> > Linchi
> >
> > "bijupg@hotmail.com" wrote:
> >
> > > Hi Guys,
> > > I am planning to upgrade my sql 2000 32 bit to sql 2005 on new cluster
> > > hardware.
> > > shall i go for 32 bit or 64 bit ?
> > > my application is a critical OLTP application with DB size around 10 gb and
> > > i hve application written using visual studio.net,VB 6.0 ,ASP and other sql
> > > servers 2000 32 bit .
> > > the upgrading to 64 bit require any modifications to the above applications?
> > > pls advice.
> > > rgds
