Accepted Solutions (0)
Answers (2)
This is not a forum for SUP questions. If you are asking about loading rows into a SQL Anywhere database, then the answer is a resounding "Yes!".
One of the best-kept secrets in the history of database products is the fact that SQL Anywhere is capable of handling whatever 99% of the world's companies can throw at it.
The truth is, SQL Anywhere is developed and maintained by a separate division within Sybase, now SAP, and the engineers work very hard to ensure it works well with large, high-volume, multi-user applications as well in small-footprint mobile environments.
The secret is, from a marketing and sales point of view HANA, IQ and ASE are SAP's enterprise offerings, so SQL Anywhere is promoted as a mobile solution... end of story, full stop, no discussion of thousand-user multi-gigabyte databases, none.
In fact, all traces of previous promotional campaigns that tell a different story are fading from view. Here's an ad from 2006, published in Issue 27 of The International Executive Search Magazine...
Here's a press release from 2004 that has been removed from the Sybase website but is still available online...
iAnywhere Database Powers High Performance Solution For Global Recruitment Consultancies
SYNOPSIS: Market-leading SQL Anywhere Studio selected as easy to use, enterprise-caliber database to address the demanding performance requirements of Microdec's clients
DUBLIN, Calif., May 10 /PRNewswire/ -- iAnywhere Solutions, Inc., a
subsidiary of Sybase, Inc. (NYSE: SY), today announced that Microdec Plc
selected SQL Anywhere(R) Studio, the market-leading database and enterprise
synchronization solution for mobile, embedded and small to medium sized
business environments. Microdec's Profile 2000 application is designed to meet
the needs of global professional recruitment consultancies and manages the
entire recruitment process from the initial registration of a client to hiring
an applicant. In a rigorous evaluation process, SQL Anywhere emerged as the
top choice to address the small to medium sized business (SMB) database
requirements of Microdec's leading clients.
"Our task in selecting a database for the Profile 2000 application was to
ensure that it could meet our clients' need for high-performance data
management and superior customer service. In addition, recognizing that our
clients often have offices throughout the world without local IT staff, the
database needed to be easy-to-use and self-administering," said Clive Seagers,
technical director at Microdec.
During the product evaluation stages, Microdec tested the SQL Anywhere-
powered Profile 2000 solution in a "model office" to assess its functionality
and ability to meet the needs of global organizations. Profile 2000 was put
through a qualified IBM benchmarking test to ensure the scalability and speed
of the underlying SQL Anywhere database and the robustness of the application.
The results revealed that the SQL Anywhere-powered solution:
-- Demonstrated high-performance running more than 1,300 active, connected
users on a single database with 30 million records.
-- Surpassed benchmark requirements on an 18 GB SQL Anywhere database with
3,900 concurrent connections.
-- Performed more than 400% faster than benchmark requirements for global
recruitment consultancies, with some search results over 4,700% faster.
-- Addressed the key requirements for ease of use and zero administration
necessary for non-technical users to run the Profile application across
a large number of distributed offices.
"Microdec's Profile 2000 application is an exciting example of the success
that our customers are achieving using SQL Anywhere to power high-performance,
multi-user server applications. The same capabilities that have made SQL
Anywhere the leader in the mobile and embedded database markets such as ease
of use, high performance out-of-the-box, small footprint and enterprise
caliber functionality, make it the perfect server database for the needs of
small to medium sized business environments," said Michael Paola, senior group
product manager at iAnywhere. "We were pleased to work closely with Microdec
throughout this evaluation process."
About SQL Anywhere Studio
SQL Anywhere is the market-leading data management and enterprise data
synchronization solution, enabling the rapid development and deployment of
database-powered applications for mobile, remote and small to medium sized
business environments.
About iAnywhere
iAnywhere is the worldwide market leader in mobile databases and mobile
middleware. More than 12,000 customers and 1,000 embedded database partners
rely on its SQL Anywhere(R) technology and mobile enterprise solutions. In
addition, its AvantGo(R) mobile Internet service has more than ten million
registered subscribers. iAnywhere is a subsidiary of Sybase, Inc. (NYSE: SY),
and its mobile technology plays an important role in the Sybase(R) Unwired
Enterprise initiative to unlock and deliver enterprise information anytime,
anywhere. Visit www.ianywhere.com for more information.
Here's "Success Story" that was last revised on Aug 19, 2011 and still remains on the Sybase website...
"SQL Anywhere was really the only database that met our requirements. In addition to its ability to scale from the single laptop or desktop to workgroups to the enterprise, SQL Anywhere can manage huge volumes of data and accommodate large numbers of concurrent users while delivering high performance, equivalent to some more costly and demanding databases. It requires virtually no maintenance, which is important because many of our customers don’t have the luxury of large IT departments with DBAs around to baby-sit databases all day."
Scott Oelfke - Product Manager for Data GIS, LMKR
| User | Count |
|---|---|
| 67 | |
| 10 | |
| 10 | |
| 10 | |
| 10 | |
| 8 | |
| 8 | |
| 7 | |
| 5 | |
| 5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.