Printable View
What is the difference between 32 bit operating system and 64 bit operating system???
Which one is faster 32 bit database server with 64 bit operating system or 64 database server with 32 bit operating system(not taking 64 bit DB server and 64 bit operating System)
Thanks
Manoj:)
The difference is straight forward. The 32-bit OS will be written for 32 bit processors (these can run on 64bit processors too) and similarly 64-bit OS are written for 64nit machines. (Ofcouse 64bit OS can not run on 32 bit processor based PCs).
The difference is simple, in 64bit OS every instruction can handle 64bit data at a time in a single instruction. For example to add two 64 bit numbers, one simple machine instruction is enough. To do the same in 32bit, we need atleast two machine instruction. So, 64-bit OS will be using 64-bit assembly language. (And 32-bit OS kuse 32bit assemply language).
As far as the comparison is concerned, I don't think 64-bit DB server can be installed in 32bit OS.
Cheers!
Kalayama
Hi Kalayama,
I dont want to install 64 bit DB on 32 Bit OS... I want to connect 64 bit DB server with 32 Bit Application Server... I want to know whether it is possible. If possible i want to know which one is faster...
Thanks
Manoj
You can make the connection you want.
As far as I know, there may or mauy not be any difference in the actual speed.
A 32 bit processor and OS (apart from the points kalayama made) can address upto 2^32 bits of memory. This amounts upto 4GB.
A 64 bit OS (with a processor of similar capability) would be able to address 2^64 bits of memory. You can have more than 4 GB of RAM on a 64 bit system ;-)
We cannot make the connection however we want... because now a days time is a critical issue... Suppose if someone ask u to decide a better stack by having these environments then its difficult to decide... That happened for me...
Thanks
Manoj:)
I though you first wanted to know whether you can make the connection or not, hence my first line.
Now the question of speed. If, like how you have described the scenario, you are given an option of connecting from a 32 bit or 64 bit OS, I would thinkthe 64 bit one is better.
You need a lot of benchmarking to determine which is faster, but my guess is 64 bit will be atleast as fast (if not faster) as the 32 bit one.
BTW you are one lucky guy for getting to make decisions like that. Most places will just give a machine and tell they dont have enough money to get a different one.
However, having not to make decisions like these may be better in one sense (just my preference for bilssful ignorence) :)
I'm sure connection can be made...
I dont know how to decide...
Ok i want to know whether Application server is playing with more data or DB is playing with more data... I think the answer for this will solve my question...
I think Application server need to be 64 bit because the lot of logics are working over here...
Whats your opinion Rachil???
Thanks
Manoj:)
Hi Manoj,
If your DB presists data for more than one application, your DB server will be a very busy one.
As you said App servers may have a lot of logic and may use lots of memory (due to objects, again this depends on how much you want your application to scale to).
In case you are using java to connect to your database, the 64 bit JVMs supposedly perform better than the 32 bit ones in the long run (thsy might start slow since they are server jvms).
The only way to find out for certain is to benchmark the two scenarios (if you have the time and 64 bit machine ofcourse :)). JMeter ([URL="http://jakarta.apache.org/jmeter/"]http://jakarta.apache.org/jmeter/[/URL]) is very good tool for benchmarking. It allows you to run tests on a server and records time and some other parameters. I have used JMeter but not for the time benchmarking purpose.
Give it a shot, it will be fun ;)