Pervasive and dual processors 1

[TomKane]

Hi,

Can Pervasive take advantage of a server that has dual processors in it? I'm taing about v8 upwards.

Thanks,
Tom

 

[mirtheil]

Does P.SQL take advantage of multiple processors? No. Will that be a problem, usually not. Pervasive is typically not CPU bound but is more disk I/O bound. The "Growing up with Pervasive" whitepaper (

http://www.pervasive.com/documentation/whitepapers/pdf/GrowingUp_white_2000i_1102.pdf)

shows some of this. It's written to 2000i but most still applies to V8.


info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[TomKane]

Thanks for that

 

[Smcmanus2001]

I have one thing to add, I have been using multi processors on Pervasive for over 2 years. I think our company was the first one to experiment with a Multiprocessor ( Quad P3 500 2 GB Ram - 2.5 Years Ago), becuse it crashed until Pervasive sent us a custom DLL to add to the Database Engine. You will definitely get a performance boost, with a Multi Processor. My current company is using a Dual P4 Xeon 3.x IBM Server, and all 4 threads are used by pervasive OR the memory manager OR but the more horse power you have and CPUs the better performance WE Get. I will Email you a JPG of the CPU Performance Graph if you want

 

[theghetto]

This is in response to Smcmanus2001's post regarding dual processors and Pervasive engine.

I was wondering what version of Pervasive you are using and the operating system its running on?

Also, what RAID configuration if any your drives are in.

Thanks for your input!

 

[Smcmanus2001]

We currently are using V 8.10 With the DRM, ODBC and the Microkernal Hotfix(have more testing to do before 8.6).

Its running on Windows 2000 Server, with 4GB of Ram, with L2 Cache Turned off using the System Cache.

Raid configuration: Raid 5 with 5-15k SCSI 320's 35Gb Each.

Hope this is useful.