Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

OS on a static drive

2 posts in General Discussion Last posting was on 2009-01-02 15:36:57.0Z
John Posted on 2008-12-29 19:56:46.0Z
Sender: 7898.4958e33a.846930886@sybase.com
From: John
Newsgroups: ianywhere.public.general
Subject: OS on a static drive
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49592b7e.2c2.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 29 Dec 2008 11:56:46 -0800
X-Trace: forums-1-dub 1230580606 10.22.241.41 (29 Dec 2008 11:56:46 -0800)
X-Original-Trace: 29 Dec 2008 11:56:46 -0800, 10.22.241.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7298
Article PK: 5512

Does SQL Anywhere 10.0.2 has any performance issues running
on a computer where OS (XP Embedded) and SQL Anywhere on a
Static Drive. Database file on a rotating drive like Seagate
36.4GB with 15K RPM.


John Smirnios [Sybase] Posted on 2009-01-02 15:36:57.0Z
From: "John Smirnios [Sybase]" <smirnios_at_sybase.com>
User-Agent: Thunderbird 2.0.0.17 (Windows/20080914)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: OS on a static drive
References: <49592b7e.2c2.1681692777@sybase.com>
In-Reply-To: <49592b7e.2c2.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <495e3499$1@forums-1-dub>
Date: 2 Jan 2009 07:36:57 -0800
X-Trace: forums-1-dub 1230910617 10.22.241.152 (2 Jan 2009 07:36:57 -0800)
X-Original-Trace: 2 Jan 2009 07:36:57 -0800, vip152.sybase.com
Lines: 29
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7303
Article PK: 5518

I can't say for sure but I can't imagine any way that having executables
on an SSD would slow anything down. Pages of executables are brought
into memory on demand (on first reference) by the OS before they can be
executed. Those pages rarely leave memory unless your system runs tight
on memory. On an SSD, paging in executable code should generally be
faster anyways and that might make startup slightly faster but no real
difference in performance afterwards.

One thing to consider is where your swap file is located if your system
is very tight on memory. In general, I'd expect the SSD to be much
faster than a rotating drive but it might be possible that if it is an
old SSD it might not have great sustained write performance. The
random-IO nature of swapping data to/from memory should generally make
having the swap file on an SSD much faster than on a spinning disk too.

-john.
--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

John wrote:
> Does SQL Anywhere 10.0.2 has any performance issues running
> on a computer where OS (XP Embedded) and SQL Anywhere on a
> Static Drive. Database file on a rotating drive like Seagate
> 36.4GB with 15K RPM.