Sybase Sql Anywhere
Using NHibernate 3.2.0 GA with SQL Anywhere 12.0.1
The 3.2.0 GA release of the NHibernate object-relational mapping toolkit was recently released on July 30. Thanks to the efforts of Julian Maughan, the base NHibernate distribution contains two SQL Anywhere dialects, named SybaseSQLAnywhere10Dialect.cs and SybaseSQLAnywhere11Dialect.cs, that can be used largely unaltered with SQL Anywhere versions 10 and 11. However, some SQL Anywhere software configuration [...]
UPDATE statements and lower isolation levels
Routinely, application developers trade off serializable transaction semantics in favour of better execution time performance by limiting the potential for lock contention. Few and far between are applications that execute at ISO/ANSI SQL isolation level 3, SERIALIZABLE. Indeed, the SQL Anywhere default isolation level is zero – READ UNCOMMITTED – except for JDBC applications, where [...]
Thoughts on DBTEST 2011
DBTEST 2011 was held on Monday, one of the co-located workshops of the 2011 ACM SIGMOD Conference in Athens, Greece and co-chaired by Ken Salem of the University of Waterloo and Goetz Graefe of HP Labs.
The workshop’s program featured eight short papers along with my keynote talk which I entitled The Peril of Complexity. [...]
A Reflection on 25 Years
Today, June 2, 2011 marks my 25th anniversary with “the company”. I put “the company” in quotes, because it is somewhat indicative of the technology industry that my “company” has undergone several name changes over the years:
WATCOM
Powersoft
Sybase
iAnywhere Solutions
Sybase iAnywhere
Sybase, An SAP Company
Those of us who have been here a while like to say: [...]
“Create Your Apportunity” fireside chat – Raj Nathan
At the recent Mobile Enterprise Summit on April 26 in San Francisco, there was a Fireside Chat titled “Create Your Apportunity”, with our own Dr Raj Nathan of Sybase and JP Finnell of GigaOM Pro.
I have been in attendance at a few of these ‘fireside‘ chats with Raj, both internal to Sybase and those open [...]
The first deadly sin – part un
In February I introduced the Seven Deadly Sins of Database Application Performance. Our first deadly sin concerns physical database design, which includes schema design issues, table column order, indexing, and choice of database page size, to name but a few important factors, that can adversely impact performance. In this article, I want to explore a [...]
The SQL Anywhere "-go_fast" option
Customers have frequently requested that we add a switch to the SQL Anywhere Server to make it run faster in their particular environment. Here in Waterloo, we have taken to calling this the mythical “dash go_fast” option. It is frequently a partner with the “dash no_crash” option.
While it would certainly be [...]
I/O Requirements for SQL Anywhere Whitepaper
Today, we published a detailed technical whitepaper: “SQL Anywhere I/O Requirements for Windows and Linux.” This paper grew out of many discussions with customers who occasionally have problems with SQL Anywhere database files. Database servers have a fundamental requirement that the database file is stored in a stable way to [...]
SQL Anywhere Web Forum Now in Production
On Friday, we made the switch, and the new SQL Anywhere web forum http://sqlanywhere-forum.sybase.com is now in production.
I would like to publicly thank Breck Carter for all he has done to foster the initial forays into a SQL Anywhere technical web forum. Through his efforts, the community is quite active, with over 690 questions [...]
Deployment of the iOS Application
To get here, over that last 8 weeks, we have mentioned using a Mobile Enterprise Application Platform (MEAP) – the Sybase UnWired Platform (SUP) to create Mobile Business Objects (MBO’s) that abstract our datasources and define what will be synchronized to our iOS Mobile Client. Creating and using an Objective-C Object API for those MBO’s [...]