Recommended Cache Size for SQLBase 9.0.1?

Discussion forum about all things SqlBase.
RainerE
Germany
Posts: 2049
Joined: 27 Apr 2021, 12:40
Location: Germany

Re: Recommended Cache Size for SQLBase 9.0.1?

Post by RainerE » 11 Jul 2014, 08:29

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

Re: Recommended Cache Size for SQLBase 9.0.1?

Post by d.richter » 11 Jul 2014, 11:20

Delete
Last edited by d.richter on 14 Jul 2014, 12:05, edited 2 times in total.

d.richter

Re: Recommended Cache Size for SQLBase 9.0.1?

Post by d.richter » 11 Jul 2014, 11:47

Rainer wrote: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

Re: Recommended Cache Size for SQLBase 9.0.1?

Post by d.richter » 14 Jul 2014, 12:05

mvandine wrote: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
Germany
Posts: 2049
Joined: 27 Apr 2021, 12:40
Location: Germany

Re: Recommended Cache Size for SQLBase 9.0.1?

Post by RainerE » 15 Jul 2014, 15:34

Please let us discusse here.

Regards,
Rainer

d.richter

Re: Recommended Cache Size for SQLBase 9.0.1?

Post by d.richter » 29 Aug 2014, 10:00

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

Mike Vandine

Re: Recommended Cache Size for SQLBase 9.0.1?

Post by Mike Vandine » 29 Aug 2014, 10:24

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

Re: Recommended Cache Size for SQLBase 9.0.1?

Post by d.richter » 14 Oct 2014, 09:10

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
India
Posts: 2176
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Re: Recommended Cache Size for SQLBase 9.0.1?

Post by FRBhote » 14 Oct 2014, 12:21

How many rows in the update?

Have you seen the execution plan for the update?

d.richter

Re: Recommended Cache Size for SQLBase 9.0.1?

Post by d.richter » 14 Oct 2014, 12:27

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

Re: Recommended Cache Size for SQLBase 9.0.1?

Post by Mike Vandine » 15 Oct 2014, 02:41

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

Re: Recommended Cache Size for SQLBase 9.0.1?

Post by d.richter » 15 Oct 2014, 08:24

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

Re: Recommended Cache Size for SQLBase 9.0.1?

Post by Mike Vandine » 16 Oct 2014, 04:04

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

Re: Recommended Cache Size for SQLBase 9.0.1?

Post by d.richter » 21 Oct 2014, 19:19

I am between Cologne and Frankfurt near Koblenz

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests