If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Pervasive.SQL > Allowing more CPU usage per user

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-10-05, 13:45
QAItech QAItech is offline
Registered User
 
Join Date: May 2005
Posts: 12
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,
Reply With Quote
  #2 (permalink)  
Old 11-10-05, 15:35
mirtheil mirtheil is offline
Registered User
 
Join Date: Dec 2001
Posts: 1,026
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.
Reply With Quote
  #3 (permalink)  
Old 11-10-05, 16:24
QAItech QAItech is offline
Registered User
 
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.
Reply With Quote
  #4 (permalink)  
Old 11-10-05, 16:30
mirtheil mirtheil is offline
Registered User
 
Join Date: Dec 2001
Posts: 1,026
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On