Results 1 to 4 of 4
  1. #1
    Join Date
    May 2005
    Posts
    12

    Unanswered: Allowing more CPU usage per user

    Is it at all possible to allocate more CPU usage per user from within Pervasive V8.6? Right now I have a user who is taking up 20% of CPU and will be the only one running queries off of the server. and instead of just using 20% they would have 40%. Is this possible and if so how is it done?

    Thanks,

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    In a word, no.
    Long answer, PSQL shares resources across all users so would not be able to specify which user gets which resources. In addition, a query may not be CPU bound (giving more CPU resources may not help) but may be I/O bound (disk subsystem is the bottleneck).
    If you're trying to speed up the query, make sure it's optimized and uses indexes.
    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.

  3. #3
    Join Date
    May 2005
    Posts
    12
    I have checked the I/O's when a query is running and seems to fine but I figured there wasn't a way within Pervasive.

    Thank you very much.

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Have you run a Check Database report on the database? What about a Query Plan? Does it show anything.
    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
  •