Breck Carter

The latest version of Adaptive Server Anywhere (ASA) marks a major turning point in the history of this product. Prior to version 8 the most important design goals were ease of use, small footprint, and cross-platform support, with high speed taking a back seat. This time, improved performance is the number one new feature. And the results? Mostly good, sometimes uneven, getting better fast. Product Description ASA is an affordable relational database management system that ships as part of the SQL Anywhere Studio package from iAnywhere Solutions, a subsidiary of Sybase. ASA supports all the features you expect from a modern RDBMS, including ANSI standard SQL, multiuser network connectivity, multiprocessor support, transaction commit and rollback, row-level locking, referential integrity, BLOBs, events and triggers, and stored procedures. Installation and Setup Inst... (more)

Synchronizing in SQL Anywhere 9

Distribution of data is the physical storage of data in different locations with access provided to the necessary data regardless of its location. Sometimes data is distributed for historical reasons; for example, when separate applications use different software and hardware. Sometimes data is distributed for a specific purpose: to speed up access by moving it closer to the end user, to improve reliability in the face of network failure, or because network connections are only occasionally available. SQL Anywhere Studio 9 offers four ways to implement distributed data: proxy ta... (more)

Table Fragmentation in SQL Anywhere 9

This is an excerpt from a new book, SQL Anywhere Studio 9 Developer's Guide, ISBN 1-55622-506-7, published this summer by Wordware Publishing. The material comes from two sections in Chapter 10, "Tuning," which discuss table fragmentation in ASA databases. The first part of this article describes how rows and columns are stored in the physical database file, how that data can become so fragmented that performance suffers, and how fragmentation can be measured. The second part presents one solution to table fragmentation, the REORGANIZE TABLE statement, and it describes several w... (more)