Recommended Cache Size for SQLBase 9.0.1?

[RainerE]

For us, we have figured out that -sadly- 64000 is the optimal cache size.
Going to 128000 is possible, speeds up some things and slows down other things (like check database/update statistics).
I would not set the cache higher.
What is most important for SQLBase performance is hard disk IO. So putting the database on a mirrored SSD would be a good idea.

Regards,
Rainer

[d.richter]

Delete

[d.richter]

For us, we have figured out that -sadly- 64000 is the optimal cache size.
Going to 128000 is possible, speeds up some things and slows down other things (like check database/update statistics).
I would not set the cache higher.
What is most important for SQLBase performance is hard disk IO. So putting the database on a mirrored SSD would be a good idea.

Regards,
Rainer

Hello, i cannot contact you with pn. We can write in german.

[d.richter]

I would modify the cache= to be cache=128000. You could also try 256000, but with the size you've got now the server will probably be spending more time managing the cache then returning data.

Another thing I would add would be:

[dbntsrv]
readonly=0

This will turn off the global readonly cache and could speed things up.

Best regards,

And what is with AsyncIO=0? Is this ok or a performance bottleneck?

[RainerE]

Please let us discusse here.

Regards,
Rainer

[d.richter]

And what is with AsyncIO=0? Is this ok or a performance bottleneck?

[Mike Vandine]

asyncio is a *very old* setting that really isn't applicable on the current multi-processor boxes. It shouldn't give you any errors if you put it in the sql.ini file, but it also will be ignored.

Best regads,

[d.richter]

Hello,

we are using now all your tipps in our sql.ini with cache 128000, but when i make a database update it hangs always and i use the old sql.ini for the update. we are now 35 user on the sqldatabase with the new sql.ini but its always slow. the application is prinance.

Any idea?

Daniel

[FRBhote]

How many rows in the update?

Have you seen the execution plan for the update?

[d.richter]

The Update is 4-5 times in a year, i have only a update.scp from the developer for thiksql. my biggest problem is the normal performance ...

[Mike Vandine]

Probably the best thing to do with 9.0.1 is to use SQLConsole to look for very high SQL Costs in the Cursor display screen. You can then have a look at the SQL Statement and the execution plan to see if there is a table scan being done (i.e. not using an index).

Also, what isolation level are you using? RL? SQLConsole will show that as well. For a multiuser system, this should be the isolation level of choice...

[d.richter]

Thanks, but my knowledge is to small. Do you a have a german consultant, who can look on our system?
When i start the SQLConsole he cannot open the log in the databasenamed folder.

[Mike Vandine]

Where are you located? Any chance that you are coming to the Developer's Conference in Berlin next week? I'll be there. If you bring your laptop with SB installed, I can help you get it running.

[d.richter]

I am between Cologne and Frankfurt near Koblenz