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.

timestamp of database in Windows Explorer

2 posts in General Discussion Last posting was on 2009-07-07 10:04:10.0Z
Aron Posted on 2009-07-06 22:20:59.0Z
Sender: 7add.4a52782a.1804289383@sybase.com
From: Aron
Newsgroups: ianywhere.public.general
Subject: timestamp of database in Windows Explorer
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a5278cb.7b66.1681692777@sybase.com>
NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
Date: 6 Jul 2009 15:20:59 -0700
X-Trace: forums-3-dub.sybase.com 1246918859 10.22.241.188 (6 Jul 2009 15:20:59 -0700)
X-Original-Trace: 6 Jul 2009 15:20:59 -0700, forums-3-dub.sybase.com
Lines: 8
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7637
Article PK: 6029

Hi, we are running SQL anywhere v8, and i noticed the
database' timestamp in windows explorer off. Sometimes by
several minutes, sometimes by hours. The reason i know this
is becasue the database is sometimes used live, but the
timestamp is still behind.

Thanks in advance.
Aron


Breck Carter [TeamSybase] Posted on 2009-07-07 10:04:10.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Re: timestamp of database in Windows Explorer
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <s2765513jilueagj7beojue8c3f0vc25vg@4ax.com>
References: <4a5278cb.7b66.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 7 Jul 2009 03:04:10 -0700
X-Trace: forums-3-dub.sybase.com 1246961050 10.22.241.152 (7 Jul 2009 03:04:10 -0700)
X-Original-Trace: 7 Jul 2009 03:04:10 -0700, vip152.sybase.com
Lines: 30
X-Authenticated-User: TeamSybase
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7638
Article PK: 6030

SQL Anywhere doesn't spend the time required to update the file
timestamp every time it makes a change to the data. On a busy database
that would happen every few milliseconds, and would reflect the last
time the file was modified... that time does not necessarily bear any
relationship to the last time the database data was modified because
you have to take into account write delays (checkpoints etcetera).

If you want that feature, make a suggestion in the
product_futures_discussion forum... present a business case about why
you need it.

Breck

On 6 Jul 2009 15:20:59 -0700, Aron wrote:

>Hi, we are running SQL anywhere v8, and i noticed the
>database' timestamp in windows explorer off. Sometimes by
>several minutes, sometimes by hours. The reason i know this
>is becasue the database is sometimes used live, but the
>timestamp is still behind.
>
>Thanks in advance.
>Aron

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com