Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Posts
    8

    Unanswered: Pervasive 8.6: Multiple Processor Support

    Hello,

    we are using Pervasive SQL 8.6 on a dual/2 CPU(Intel) Windows 2003
    based server.
    Visually checking CPU-load in "Windows Task Manager" during "DB-actions"
    doesen't gives me the impression,that multiple processors are involved
    in working..

    1.
    Is there a way to find out if Perasiv does take advantage of multiple CPU's?
    2.
    How much does a second processor normally increase "DB-operations?
    (we are are using a mirrored/RAID1 SCSI U320 array)


    Any feedback is appreciated very much. Thank you!

    John

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    PSQL does not specifically take advantage of multiple processors. The OS may shuffle some operations to additional processors though.
    Any performance increases would probably be minimal. Most PSQL DB operations are not CPU bound but I/O bound. That means that the DB is not waiting on the CPU but is waiting for the disk subsystem.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •