Is there a way for a function to determine if a given table is using an auto-increment field as it's primary key? I have a database that has some tables where the current Pkey is stored in a separate table, and other tables are using autoincrement. ...
Running SQLAnywhere 17, relatively current patched. Hosts the database for our ERP system. The .db file is appx 75gb. Yesterday,everything was fine, but this morning entering the sales module started throwing this error:
Database transaction infor...
I find myself needing to determine the date of, for example, the next Monday following today. I came up with the following code. While readable, it seems to me that there is probably a more elegant solution. I'm using WinSQL, so the '::DayID' is a...
We are considering changing our on-prem Sybase SQL Anywhere 17 database host from Windows 2016 to Linux. We are virtualized (VMWare), and the datastores are on an iSCSI SAN connected with 10Gb. The motivation is the quest for increased performance, ...
Following this out of curiosity. What is driving the need to use 32K pages? My understanding has always been that there's a little voodoo to tuning the page size, to balance storage efficiency vs. performance, and one of the key factors is record w...
In addition to what Volker said, what are the disk sub-systems in play? SSD on your PC, but iSCSI over ethernet on the server would have a negative impact.
Our ERP system is written in an elderly version of PowerBuilder. We had no issues with the upgrade from 16 to 17 when we did it a few years back. I was cautious enough to make sure all the clients got the v17 ODBC drivers, though in testing we didn...
@Chris -- the challenge is that I did not design this database, though I have added tables to it. The ERP app that uses the DB expects to be able to get the key values for it's data from a 'key table'. The tables I've added all use autoincrement. ...
