Sybase ASE 15 supports the use of many optimization techniques and tools. The use of these tools requires an expert level of understanding since improper application of query optimization tools can degrade performance for ASE as a whole. In this excerpt, the following optimization techniques are discussed from a standpoint of how to recognize problems resulting from the improper application of optimization strategies in ASE 15.

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.

This two-part article provides a primer on OLE, some practical examples of its use, and demonstrates some methods for addressing the limitations of PowerBuilder's implementation of OLE.

Using Object Linking and Embedding (OLE) from PowerBuilder - whether in OLE Automation or the use of ActiveX controls - has long been a source of frustration for many PowerBuilder developers.

Sybase's Adaptive Server Anywhere (ASA) is a small footprint, low maintenance database designed for mobile, embedded, personal and workgroup settings. In spite of its compact nature, it still provides all the 'big iron' features, such as replication, synchronization, and Java in the database.

In this article we'll discuss connectivity requirements, Informix-specific data type processing, and the use of Informix stored procedures within the PowerBuilder environment.

In this article we'll discuss connectivity requirements, Informix-specific data type processing, and the use of Informix stored procedures within the PowerBuilder environment.

An enterprise portal is the converged 'hub' of multiple, complementary information management solutions, including document and content management, information search and retrieval, knowledge management, team collaboration, workflow, and business intelligence.

An enterprise portal is the converged 'hub' of multiple, complementary information management solutions, including document and content management, information search and retrieval, knowledge management, team collaboration, workflow, and business intelligence.