64 bit architecture and Ingres II 2.5

64 bit architecture and Ingres II 2.5

Post by cweisenber.. » Wed, 15 Jan 2003 18:58:47



Hi all,
we are in progress to migrate from HPUX 10.20 to HPUX 11i and from Ingres
II 2.0 to Ingres II 2.5.

Now the question arised, whether Ingres II 2.5 does take use of the 64 bit
architecture of HPUX.
Furthermore managment asks, whether we got a performance degree, if Ingres
2.5 is not
using all the features of the 64 bit architecture.

Does anyone have experience with HPUX 11i and OS threads?
Do they work fine now? Or is it still better to work with internal threads?

Thanks for your hints and suggestions.

Hans Weisenberger

 
 
 

64 bit architecture and Ingres II 2.5

Post by Karl & Betty Schend » Wed, 15 Jan 2003 22:13:27



Quote:>we are in progress to migrate from HPUX 10.20 to HPUX 11i and from Ingres
>II 2.0 to Ingres II 2.5.

>Now the question arised, whether Ingres II 2.5 does take use of the 64 bit
>architecture of HPUX.
>Furthermore managment asks, whether we got a performance degree, if Ingres
>2.5 is not
>using all the features of the 64 bit architecture.

Ingres 2.5 is still a 32-bit program in the sense that it uses a 32-bit
memory architecture and 32-bit pointers.  It uses the large file API for
file accessing, though, so it is not restricted by the 32 bit limit for
file sizes.

Yes, you still get a performance increase (and quite a significant one)
going from 2.0 to 2.5.  I don't have personal experience of 11i but I
imagine that it runs at least as well as 10.20 and probably a bit better.

Realize that larger is not always better (not even for Americans!).
Unless you are going to do something significant with your 64-bit address
space, like cache entire tables, a 64-bit program can actually be larger
and run slower than the 32-bit version of the same program.  You have more
bits to push around, and the caches are polluted with useless extra bits.

Quote:

>Does anyone have experience with HPUX 11i and OS threads?
>Do they work fine now? Or is it still better to work with internal threads?

That one I don't have an answer to.

--

K/B Computer Associates       www.kbcomputer.com
Ingres, Unix, VMS             Consulting and Training

 
 
 

1. Ingres II 2.0 on Solaris 2.7 - 32 bit mode or 64 bit mode

Apart from the issue with syscheck not working in 64 bit mode, does
anyone have any advice on which mode is preferable.

We are running in 64 bit mode - at this stage I feel that 32 bit mode
may be the better way to go, as I am playing with config params & not
having syscheck run is a bit of a risk. (I've read thru old postings,
and I realise that syscheck cannot be relied on 100%, but surely its
better than nothing).

Are there any benefits with 64bit mode? Is it faster? Is there a good
reason NOT go go to 32 bit mode? (The apps we run do not require 64
bit mode).

2. Importing Text File into DataBase Slow !

3. Ingres 2.5 on 64 bit SunFire 280R

4. Liciensing Issue

5. 64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new !

6. Error Handling

7. 64 Bit Informix on a 64 bit V-Class

8. DTSRun error in sending email

9. Problems with 64 bit IDS and Omniback II

10. Ingres installation problem - Ingres II 2.5 on hp-ux 11

11. Ingres 2.6 on Solaris 8 [ on 64 bit sparc machine]

12. Beta Program of 64-bi DB2 on 64-bit Windows .Net and Intel-based IPF systems

13. 64-bit SQL Server and 32-bit dlls question