Hi All,
As far as I know, there is a recommendation that the size of the database page and the size of the cluster (sector) of the file system (for example, NTFS) where the database is located are the same. Thanks to this, when reading one database p...
Hi,
As far as I know, in SAW SQL Anywhere 17 and below it can be a maximum of 13 table spaces (1 main and 12 additional).
Question: Why is there such a restriction ? Why can there be 13 table spaces, and not say 255 ?
Hi,
SAP SQL AnyWhere 17.0.10 x64
There is a database with a page size of 16 kb. There is a need to increase
the size of the database page to the maximum, that is, up to 32 kb.
Will this affect the performance of the database server and the speed of ...
Hi All,
There is SA server 12.0.1.4134 with a working database.
The server starts running the following command:
dbsrv12.exe @config_base.txt
This is the contents of the config_base.txt file:
-dt C:\\TEMP
-c 2G
-n test_web
-x tcpip(MyIP=0.0.0.0;Serv...
Thanks for the link, I'll read it.
But what if it’s the other way around, that is, the size of the database page (for example, 16 kb)) is larger than the size of the cluster (sector) of the file system (for example, NTFS 4 kb)?
I am interested in thi...
The "PK_DOCUMENTTEXT" index should be used for the condition according to the main table "DOCUMENTTEXT" - and I have it used.
But the "PK_TEXTS_CA_1" index should be used for the reinforcement of the main table "DOCUMENTTEXT" and "CatextView". But fo...
In a week, users retain on an average of 15 GB in the database of texts of documents. I can fill each table space no more than 75% of its size (this is necessary so that there is still a place to change the file previously saved there). I am still fa...
My server version is 17.0.10.5866.
Perhaps in a newer version of the server, the work of the query optimizer has been improved.
Did I understand you correctly that when performing the second blocking you used the index “PK_TEXTS_CA_1” ?
If you abandon dba.CaTextView and use this query:
select
DOCUMENTTEXT.IDENTITY,
DOCUMENTTEXT.DOCNAME,
(case DOCUMENTTEXT.TEXTFILENUMBER
when 1 then TEXTS_CA_1.DOCDATE
when 2 then TEXTS_CA_2.DOCDATE
else
null
end) as DOCDATE,
from db...
