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?
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.
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.