How do I limit system resources for query execution

[hanso]

Hi,

When I run a query on the server the SRDE uses all processor resources on the server available. Is there anyway to limt this?

Thanks for any help.

Hans

 

[TomKane]

Hans,

You could check two things:

First of all how Pervasive is set up on your server - there could be something you could do in terms of configuration.

Secondly, the queries you are running may not be the most efficient - I don't mean that as a criticism - we found that doing inner joins was a waste of time the queries just crawled - left outer joins were the only way to go.

Hope this helps,

Tom

 

[hanso]

Tom,

I checked all possible configuration items and alse the helpfile concerning this issue. Unfortunately Pervasive runs on Novell Netware 5.1 at our site so not all options are available to me.

Furthermore this situation also occurs running the simplest of queries (select * from table). Also especially the complex queries are the ones I would like to limit the resources for.

 

[TomKane]

Hanso,

You could always go the other way with this. If you get the software developers kit you can use transactional functionality - it's kind of like the old-style Cobol Start and Read Next. Transactional is much much quicker than using SQL queries.

Regards,

Tom

 

[Vancouverite]

What service pack are you on? This was an especially large issue on Pervasive.SQL / Novell prior to SP3.

I recommend that you Upgrade to SP4. We are not having this 100% on one query issue anymore.

 

[hanso]

We are on Novell 5.1 SP3 with Pervasive.SQL 200i (SP3), we' re just considering upgrading (both) to SP4. Do I understand correctly you had this issue up untill you upgraded to SP4 ?