I have just noticed that on a dual Quad Xeon server with Pervasive 9.7x that it only seems to use one of the 8 processors shown in Task manager.
If I do something like view data or execute a SQL statement or evn just open a table in the Pervasive Control, it only peaks on one CPU.
Could it be that this explains why the databse is slow?
Is there a way to specify how many CPU's the server engine may use?
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have.