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.

SQL Anywhere 10.0 Features

11 posts in General Discussion Last posting was on 2006-11-10 07:58:04.0Z
KJetley Posted on 2006-11-06 17:52:07.0Z
Sender: 17e1.454f7ed8.1804289383@sybase.com
From: KJetley
Newsgroups: ianywhere.public.general
Subject: SQL Anywhere 10.0 Features
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <454f8457.183d.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 Nov 2006 10:52:07 -0700
X-Trace: forums-1-dub 1162839127 10.22.241.41 (6 Nov 2006 10:52:07 -0700)
X-Original-Trace: 6 Nov 2006 10:52:07 -0700, 10.22.241.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5706
Article PK: 1710

Does anyone know if the following features are supported in
SQL Anywhere 10.0:

-Table partioning?
-Separate Log file locations from the *.db file?
-What is the maximum memory hardware setting that SQL
Anywhere supports?
-For optimal queries, is there a way to update schema
statistics?

Thanks for any input!


Greg Fenton Posted on 2006-11-06 18:50:11.0Z
From: Greg Fenton <greg.fenton@googles-mail-site>
User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: SQL Anywhere 10.0 Features
References: <454f8457.183d.1681692777@sybase.com>
In-Reply-To: <454f8457.183d.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: wsp04839138wss.cr.net.cable.rogers.com
X-Original-NNTP-Posting-Host: wsp04839138wss.cr.net.cable.rogers.com
Message-ID: <454f91f3$2@forums-1-dub>
Date: 6 Nov 2006 11:50:11 -0700
X-Trace: forums-1-dub 1162842611 24.235.100.122 (6 Nov 2006 11:50:11 -0700)
X-Original-Trace: 6 Nov 2006 11:50:11 -0700, wsp04839138wss.cr.net.cable.rogers.com
Lines: 28
X-Authenticated-User: sa_beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5709
Article PK: 1712


KJetley wrote:
> Does anyone know if the following features are supported in
> SQL Anywhere 10.0:
>
> -Table partioning?

Describe what you mean by this.

> -Separate Log file locations from the *.db file?

Yes, as does v6, v7, v8 and v9 (and probably all versions prior to that).

> -What is the maximum memory hardware setting that SQL
> Anywhere supports?

Which OS and version are you running on?

> -For optimal queries, is there a way to update schema
> statistics?

CREATE STATISTICS <tablename> will recreate the stats, but you shouldn't
need to do that as the engine maintains stats automatically (unless you
run into some sort of bug where the stats aren't updating).

g.f
--
Greg Fenton
Some Random Dude


KJetley Posted on 2006-11-06 19:57:03.0Z
Sender: 17e1.454f7ed8.1804289383@sybase.com
From: Kjetley
Newsgroups: ianywhere.public.general
Subject: Re: SQL Anywhere 10.0 Features
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <454fa19f.1a78.1681692777@sybase.com>
References: <454f91f3$2@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 Nov 2006 12:57:03 -0700
X-Trace: forums-1-dub 1162846623 10.22.241.41 (6 Nov 2006 12:57:03 -0700)
X-Original-Trace: 6 Nov 2006 12:57:03 -0700, 10.22.241.41
Lines: 45
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5710
Article PK: 1714


> KJetley wrote:
> > Does anyone know if the following features are supported
> > in SQL Anywhere 10.0:
> >
> > -Table partioning?

>
> Describe what you mean by this.

Kjetley[The ability to either horizontally(by data qty) or
vertically(by columns) split tables into paritioned parts to
make reads/inserts quicker.]
>
> > -Separate Log file locations from the *.db file?
>
> Yes, as does v6, v7, v8 and v9 (and probably all versions
> prior to that).
>
> > -What is the maximum memory hardware setting that SQL
> > Anywhere supports?
>
> Which OS and version are you running on?
Kjetley[Running on Windows Server 2003]
>
> > -For optimal queries, is there a way to update schema
> > statistics?
>
> CREATE STATISTICS <tablename> will recreate the stats, but
> you shouldn't need to do that as the engine maintains
> stats automatically (unless you run into some sort of bug
> where the stats aren't updating).

Kjetley[In SQL Server for multi-million row queries,
updating statistics explicitly is more optimal than just the
engine-that is why I was asking?]

Kjetley[Is reindexing supported for clustered indexes?]

Kjetley[Can SQL Anywhere Studio support 500 GB databases or
is that better suited for SQL Server or Oracle, etc..?]
>
> g.f
> --
> Greg Fenton
> Some Random Dude


Glenn Paulley Posted on 2006-11-07 13:37:30.0Z
Newsgroups: ianywhere.public.general
Subject: Re: SQL Anywhere 10.0 Features
From: Glenn Paulley <paulley@ianywhere.com>
References: <454f91f3$2@forums-1-dub> <454fa19f.1a78.1681692777@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns987460EC5F146paulleyianywherecom@10.22.241.106>
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: paulley-t41.sybase.com
X-Original-NNTP-Posting-Host: paulley-t41.sybase.com
Date: 7 Nov 2006 06:37:30 -0700
X-Trace: forums-1-dub 1162910250 10.25.99.149 (7 Nov 2006 06:37:30 -0700)
X-Original-Trace: 7 Nov 2006 06:37:30 -0700, paulley-t41.sybase.com
Lines: 21
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5712
Article PK: 1715

We are aware of existing SQL Anywhere 9.x customers who have databases of
500Gb or greater.

Kjetley wrote in news:454fa19f.1a78.1681692777@sybase.com:

> Kjetley[Can SQL Anywhere Studio support 500 GB databases or
> is that better suited for SQL Server or Oracle, etc..?]
>>

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

Register now for TechWave 2006 August 6-10 in Las Vegas. New! 2-day
and 4-day options for SQL Anywhere technical training. Sessions will
focus on data management, data movement, and SQL Anywhere 10. Visit
www.sybase.com/techwave

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all


"Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g Posted on 2006-11-06 22:59:22.0Z
From: "Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com>
Organization: iAnywhere Solutions
User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: SQL Anywhere 10.0 Features
References: <454f91f3$2@forums-1-dub> <454fa19f.1a78.1681692777@sybase.com>
In-Reply-To: <454fa19f.1a78.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
Message-ID: <454fcc5a$1@forums-1-dub>
Date: 6 Nov 2006 15:59:22 -0700
X-Trace: forums-1-dub 1162857562 24.43.0.24 (6 Nov 2006 15:59:22 -0700)
X-Original-Trace: 6 Nov 2006 15:59:22 -0700, cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
Lines: 56
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5711
Article PK: 1719

>>-Table partioning?

AFAIK this is being considered.

>>-What is the maximum memory hardware setting that SQL

>>Anywhere supports?

The limits are OS specific. For Win2003 Server (32 bit), the limit is
1.8 or 2.3 GBs for Enterprise/DataCenter. For AWE cache, 100% of
available memory. For 64 bit, limited by physical memory.

>>-For optimal queries, is there a way to update schema
>>statistics?
I am still not following? SQL Anywhere updates statistics automatically
as queries are executed. You can also manually update statistics using
CREATE STATISTICS statement, if needed or required (a skew in the
statistics).

>>Kjetley[Is reindexing supported for clustered indexes?]
You can REORGANIZE the index if the clustered index values are no longer
clustered.

>>Kjetley[Can SQL Anywhere Studio support 500 GB databases or
>>is that better suited for SQL Server or Oracle, etc..?]
SQL Anywhere should be able to handle this volume of data without too
much difficulty assuming a reasonably well designed schema and
application architecture for those applications that interact with the
databaase. The real issue is the management of this database size i.e.,
backups, reloads, etc. SQL Anywhere 10 has a focus on improvements in
the management of larger databases.


--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************

Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************


Gudjon Adalsteinsson Posted on 2006-11-09 12:23:37.0Z
Reply-To: "Gudjon Adalsteinsson" <gudjon@fjarvirkni.is>
From: "Gudjon Adalsteinsson" <gudjon@fjarvirkni.is>
Newsgroups: ianywhere.public.general
References: <454f91f3$2@forums-1-dub> <454fa19f.1a78.1681692777@sybase.com> <454fcc5a$1@forums-1-dub>
Subject: Re: SQL Anywhere 10.0 Features
Lines: 72
Organization: Fjarvirkni ehf
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: dsl-196-33.hive.is
X-Original-NNTP-Posting-Host: dsl-196-33.hive.is
Message-ID: <45532bd9$1@forums-1-dub>
Date: 9 Nov 2006 05:23:37 -0700
X-Trace: forums-1-dub 1163078617 85.197.196.33 (9 Nov 2006 05:23:37 -0700)
X-Original-Trace: 9 Nov 2006 05:23:37 -0700, dsl-196-33.hive.is
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5716
Article PK: 1723

Table partioning would be a very nice feature to have. I have many years of
data in my database (7GB) and it is being backed up every night, sent over
the network to storage where 30 backups are being kept. Data entered last
year will not change and it seems pretty stupid backing it up all the time
and also large files are quite cumbersome. But all the data has to be
accessible all the time for viewing.
It would be nice if I could keep e.g. one file for last 12 months and older
data in a separate file WITHOUT having to alter anything in the software.
Is something like this being considered ?
(What does AFAIK mean?)
Gudjon

"Chris Keating(iAnywhere Solutions)"

<NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com> wrote in message
news:454fcc5a$1@forums-1-dub...
> >>-Table partioning?
>
> AFAIK this is being considered.
>
> >>-What is the maximum memory hardware setting that SQL
> >>Anywhere supports?
>
> The limits are OS specific. For Win2003 Server (32 bit), the limit is 1.8
> or 2.3 GBs for Enterprise/DataCenter. For AWE cache, 100% of available
> memory. For 64 bit, limited by physical memory.
>
> >>-For optimal queries, is there a way to update schema
> >>statistics?
> I am still not following? SQL Anywhere updates statistics automatically as
> queries are executed. You can also manually update statistics using CREATE
> STATISTICS statement, if needed or required (a skew in the statistics).
>
> >>Kjetley[Is reindexing supported for clustered indexes?]
> You can REORGANIZE the index if the clustered index values are no longer
> clustered.
>
> >>Kjetley[Can SQL Anywhere Studio support 500 GB databases or
> >>is that better suited for SQL Server or Oracle, etc..?]
> SQL Anywhere should be able to handle this volume of data without too much
> difficulty assuming a reasonably well designed schema and application
> architecture for those applications that interact with the databaase. The
> real issue is the management of this database size i.e., backups, reloads,
> etc. SQL Anywhere 10 has a focus on improvements in the management of
> larger databases.
>
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
> *****************************************************************************
>
> Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
> =and try out the market-leading database for mobile, embedded and small to
> medium sized business environments for free!
>
> http://www.ianywhere.com/promos/deved/index.html
>
> *****************************************************************************
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use Case Express to report bugs http://case-express.sybase.com
>
> *****************************************************************************


Shao Chan Posted on 2006-11-09 15:11:34.0Z
From: "Shao Chan" <noemail@noemail.com>
Newsgroups: ianywhere.public.general
References: <454f91f3$2@forums-1-dub> <454fa19f.1a78.1681692777@sybase.com> <454fcc5a$1@forums-1-dub> <45532bd9$1@forums-1-dub>
Subject: Re: SQL Anywhere 10.0 Features
Lines: 92
Organization: VT Software
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
NNTP-Posting-Host: i-83-67-79-206.freedom2surf.net
X-Original-NNTP-Posting-Host: i-83-67-79-206.freedom2surf.net
Message-ID: <45535336@forums-1-dub>
Date: 9 Nov 2006 08:11:34 -0700
X-Trace: forums-1-dub 1163088694 83.67.79.206 (9 Nov 2006 08:11:34 -0700)
X-Original-Trace: 9 Nov 2006 08:11:34 -0700, i-83-67-79-206.freedom2surf.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5718
Article PK: 1720

I am not sure how table partitioning is addressed in all databases, but
whilst you'd gain in query performance, I didn't know it made any difference
to your backup. You either backup incrementally which backs up the changes
wherever they sit, or you backup the whole database anyway right? Even if
the database is split between several files, they have signatures for
integrity right?

How does table partitioning assist in this?

Cheers,

Shao

"Gudjon Adalsteinsson" <gudjon@fjarvirkni.is> wrote in message
news:45532bd9$1@forums-1-dub...
> Table partioning would be a very nice feature to have. I have many years
> of data in my database (7GB) and it is being backed up every night, sent
> over the network to storage where 30 backups are being kept. Data entered
> last year will not change and it seems pretty stupid backing it up all the
> time and also large files are quite cumbersome. But all the data has to
> be accessible all the time for viewing.
> It would be nice if I could keep e.g. one file for last 12 months and
> older data in a separate file WITHOUT having to alter anything in the
> software.
> Is something like this being considered ?
> (What does AFAIK mean?)
> Gudjon
>
> "Chris Keating(iAnywhere Solutions)"
> <NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com> wrote in message
> news:454fcc5a$1@forums-1-dub...
>> >>-Table partioning?
>>
>> AFAIK this is being considered.
>>
>> >>-What is the maximum memory hardware setting that SQL
>> >>Anywhere supports?
>>
>> The limits are OS specific. For Win2003 Server (32 bit), the limit is 1.8
>> or 2.3 GBs for Enterprise/DataCenter. For AWE cache, 100% of available
>> memory. For 64 bit, limited by physical memory.
>>
>> >>-For optimal queries, is there a way to update schema
>> >>statistics?
>> I am still not following? SQL Anywhere updates statistics automatically
>> as queries are executed. You can also manually update statistics using
>> CREATE STATISTICS statement, if needed or required (a skew in the
>> statistics).
>>
>> >>Kjetley[Is reindexing supported for clustered indexes?]
>> You can REORGANIZE the index if the clustered index values are no longer
>> clustered.
>>
>> >>Kjetley[Can SQL Anywhere Studio support 500 GB databases or
>> >>is that better suited for SQL Server or Oracle, etc..?]
>> SQL Anywhere should be able to handle this volume of data without too
>> much difficulty assuming a reasonably well designed schema and
>> application architecture for those applications that interact with the
>> databaase. The real issue is the management of this database size i.e.,
>> backups, reloads, etc. SQL Anywhere 10 has a focus on improvements in the
>> management of larger databases.
>>
>>
>> --
>>
>> Chris Keating
>> Sybase Adaptive Server Anywhere Professional Version 8
>>
>> *****************************************************************************
>>
>> Sign up today for your copy of the SQL Anywhere Studio 9 Developer
>> Edition =and try out the market-leading database for mobile, embedded and
>> small to medium sized business environments for free!
>>
>> http://www.ianywhere.com/promos/deved/index.html
>>
>> *****************************************************************************
>>
>> iAnywhere Solutions http://www.iAnywhere.com
>>
>> ** Please only post to the newsgroup
>>
>> ** Whitepapers can be found at http://www.iAnywhere.com/developer
>> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
>> ** Use Case Express to report bugs http://case-express.sybase.com
>>
>> *****************************************************************************
>
>


Gudjon Adalsteinsson Posted on 2006-11-09 17:18:10.0Z
Reply-To: "Gudjon Adalsteinsson" <gudjon@fjarvirkni.is>
From: "Gudjon Adalsteinsson" <gudjon@fjarvirkni.is>
Newsgroups: ianywhere.public.general
References: <454f91f3$2@forums-1-dub> <454fa19f.1a78.1681692777@sybase.com> <454fcc5a$1@forums-1-dub> <45532bd9$1@forums-1-dub> <45535336@forums-1-dub>
Subject: Re: SQL Anywhere 10.0 Features
Lines: 113
Organization: Fjarvirkni ehf
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: dsl-196-33.hive.is
X-Original-NNTP-Posting-Host: dsl-196-33.hive.is
Message-ID: <455370e2$1@forums-1-dub>
Date: 9 Nov 2006 10:18:10 -0700
X-Trace: forums-1-dub 1163096290 85.197.196.33 (9 Nov 2006 10:18:10 -0700)
X-Original-Trace: 9 Nov 2006 10:18:10 -0700, dsl-196-33.hive.is
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5720
Article PK: 1724

Well I am so oldfashioned that I only take full backups. I don't really
trust the logs. I my case (measurement system) data is collected, verified,
calculated, imported, exported in over a few week periode (window). After
that the data is "locked" and only used viewing (only select commands). So
the locked part does not really need further backups - at that point in time
you can make a permanent copies and lock them in the vault(s) :-|

As my database is 7GB and 30 day backups take only 210GB. My friends have
20GB database so that is not much either. But copying these databases
between machines, zipping them, sending them to out-of-house storage,
unloading and reloading (e.g. version upgrades) that takes time and is
frustrating when you have to wait for it :-!

Besides - small is beautiful.

Gudjon

"Shao Chan" <noemail@noemail.com> wrote in message
news:45535336@forums-1-dub...
>I am not sure how table partitioning is addressed in all databases, but
>whilst you'd gain in query performance, I didn't know it made any
>difference to your backup. You either backup incrementally which backs up
>the changes wherever they sit, or you backup the whole database anyway
>right? Even if the database is split between several files, they have
>signatures for integrity right?
>
> How does table partitioning assist in this?
>
> Cheers,
>
> Shao
>
>
> "Gudjon Adalsteinsson" <gudjon@fjarvirkni.is> wrote in message
> news:45532bd9$1@forums-1-dub...
>> Table partioning would be a very nice feature to have. I have many years
>> of data in my database (7GB) and it is being backed up every night, sent
>> over the network to storage where 30 backups are being kept. Data
>> entered last year will not change and it seems pretty stupid backing it
>> up all the time and also large files are quite cumbersome. But all the
>> data has to be accessible all the time for viewing.
>> It would be nice if I could keep e.g. one file for last 12 months and
>> older data in a separate file WITHOUT having to alter anything in the
>> software.
>> Is something like this being considered ?
>> (What does AFAIK mean?)
>> Gudjon
>>
>> "Chris Keating(iAnywhere Solutions)"
>> <NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com> wrote in message
>> news:454fcc5a$1@forums-1-dub...
>>> >>-Table partioning?
>>>
>>> AFAIK this is being considered.
>>>
>>> >>-What is the maximum memory hardware setting that SQL
>>> >>Anywhere supports?
>>>
>>> The limits are OS specific. For Win2003 Server (32 bit), the limit is
>>> 1.8 or 2.3 GBs for Enterprise/DataCenter. For AWE cache, 100% of
>>> available memory. For 64 bit, limited by physical memory.
>>>
>>> >>-For optimal queries, is there a way to update schema
>>> >>statistics?
>>> I am still not following? SQL Anywhere updates statistics automatically
>>> as queries are executed. You can also manually update statistics using
>>> CREATE STATISTICS statement, if needed or required (a skew in the
>>> statistics).
>>>
>>> >>Kjetley[Is reindexing supported for clustered indexes?]
>>> You can REORGANIZE the index if the clustered index values are no longer
>>> clustered.
>>>
>>> >>Kjetley[Can SQL Anywhere Studio support 500 GB databases or
>>> >>is that better suited for SQL Server or Oracle, etc..?]
>>> SQL Anywhere should be able to handle this volume of data without too
>>> much difficulty assuming a reasonably well designed schema and
>>> application architecture for those applications that interact with the
>>> databaase. The real issue is the management of this database size i.e.,
>>> backups, reloads, etc. SQL Anywhere 10 has a focus on improvements in
>>> the management of larger databases.
>>>
>>>
>>> --
>>>
>>> Chris Keating
>>> Sybase Adaptive Server Anywhere Professional Version 8
>>>
>>> *****************************************************************************
>>>
>>> Sign up today for your copy of the SQL Anywhere Studio 9 Developer
>>> Edition =and try out the market-leading database for mobile, embedded
>>> and small to medium sized business environments for free!
>>>
>>> http://www.ianywhere.com/promos/deved/index.html
>>>
>>> *****************************************************************************
>>>
>>> iAnywhere Solutions http://www.iAnywhere.com
>>>
>>> ** Please only post to the newsgroup
>>>
>>> ** Whitepapers can be found at http://www.iAnywhere.com/developer
>>> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
>>> ** Use Case Express to report bugs http://case-express.sybase.com
>>>
>>> *****************************************************************************
>>
>>
>
>


Greg Fenton Posted on 2006-11-09 17:48:54.0Z
From: Greg Fenton <greg.fenton@googles-mail-site>
User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: SQL Anywhere 10.0 Features
References: <454f91f3$2@forums-1-dub> <454fa19f.1a78.1681692777@sybase.com> <454fcc5a$1@forums-1-dub> <45532bd9$1@forums-1-dub> <45535336@forums-1-dub> <455370e2$1@forums-1-dub>
In-Reply-To: <455370e2$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: wsp04839138wss.cr.net.cable.rogers.com
X-Original-NNTP-Posting-Host: wsp04839138wss.cr.net.cable.rogers.com
Message-ID: <45537816$2@forums-1-dub>
Date: 9 Nov 2006 10:48:54 -0700
X-Trace: forums-1-dub 1163098134 24.235.100.122 (9 Nov 2006 10:48:54 -0700)
X-Original-Trace: 9 Nov 2006 10:48:54 -0700, wsp04839138wss.cr.net.cable.rogers.com
Lines: 23
X-Authenticated-User: sa_beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5721
Article PK: 1725


Gudjon Adalsteinsson wrote:
> Well I am so oldfashioned that I only take full backups. I don't really
> trust the logs.

Hmmm...in many ways the logs are the most important part of your system.
If you lose the .db to corruption, you are completely hosed. If you
have backups of all of your logs, you can rebuild your .db to any point.
If your server should go down unexpectedly, it is the logs that will
bring you back to life, not the .db (if you only have the .db file,
you'd lose all outstanding transactions).

>
> Besides - small is beautiful.
>

Isn't that the point of backing up just the .logs (with infrequent
backups of the entire .db) ?


g.f
--
Greg Fenton
Some Random Dude


Shao Chan Posted on 2006-11-10 07:58:04.0Z
From: "Shao Chan" <noemail@noemail.com>
Newsgroups: ianywhere.public.general
References: <454f91f3$2@forums-1-dub> <454fa19f.1a78.1681692777@sybase.com> <454fcc5a$1@forums-1-dub> <45532bd9$1@forums-1-dub> <45535336@forums-1-dub> <455370e2$1@forums-1-dub>
Subject: Re: SQL Anywhere 10.0 Features
Lines: 136
Organization: VT Software
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: i-83-67-79-206.freedom2surf.net
X-Original-NNTP-Posting-Host: i-83-67-79-206.freedom2surf.net
Message-ID: <45543f1c$1@forums-1-dub>
Date: 10 Nov 2006 00:58:04 -0700
X-Trace: forums-1-dub 1163149084 83.67.79.206 (10 Nov 2006 00:58:04 -0700)
X-Original-Trace: 10 Nov 2006 00:58:04 -0700, i-83-67-79-206.freedom2surf.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5722
Article PK: 1726

Yes, but my point is that when you perform a horizontal partition of a
database, whether the data sits in a different table or storage area for
performance, a full backup still needs all of the data right? Are you
saying that it is possible to perform a horizontal partition of a database
such that you can then say 'backup everything except that horizontal
partition of that table because its old data that does not change'? As far
as I can tell, you can't really do that - but I have not had a chance to
investigate this configuration with our various technologies. If you are
able to do that, what happens when you perform a restore? Can you chop bits
from different backups because the majority of old data that has never
changed comes from a very old backup?

Cheers,

SHao

"Gudjon Adalsteinsson" <gudjon@fjarvirkni.is> wrote in message
news:455370e2$1@forums-1-dub...
> Well I am so oldfashioned that I only take full backups. I don't really
> trust the logs. I my case (measurement system) data is collected,
> verified, calculated, imported, exported in over a few week periode
> (window). After that the data is "locked" and only used viewing (only
> select commands). So the locked part does not really need further
> backups - at that point in time you can make a permanent copies and lock
> them in the vault(s) :-|
>
> As my database is 7GB and 30 day backups take only 210GB. My friends have
> 20GB database so that is not much either. But copying these databases
> between machines, zipping them, sending them to out-of-house storage,
> unloading and reloading (e.g. version upgrades) that takes time and is
> frustrating when you have to wait for it :-!
>
> Besides - small is beautiful.
>
> Gudjon
>
> "Shao Chan" <noemail@noemail.com> wrote in message
> news:45535336@forums-1-dub...
>>I am not sure how table partitioning is addressed in all databases, but
>>whilst you'd gain in query performance, I didn't know it made any
>>difference to your backup. You either backup incrementally which backs up
>>the changes wherever they sit, or you backup the whole database anyway
>>right? Even if the database is split between several files, they have
>>signatures for integrity right?
>>
>> How does table partitioning assist in this?
>>
>> Cheers,
>>
>> Shao
>>
>>
>> "Gudjon Adalsteinsson" <gudjon@fjarvirkni.is> wrote in message
>> news:45532bd9$1@forums-1-dub...
>>> Table partioning would be a very nice feature to have. I have many
>>> years of data in my database (7GB) and it is being backed up every
>>> night, sent over the network to storage where 30 backups are being kept.
>>> Data entered last year will not change and it seems pretty stupid
>>> backing it up all the time and also large files are quite cumbersome.
>>> But all the data has to be accessible all the time for viewing.
>>> It would be nice if I could keep e.g. one file for last 12 months and
>>> older data in a separate file WITHOUT having to alter anything in the
>>> software.
>>> Is something like this being considered ?
>>> (What does AFAIK mean?)
>>> Gudjon
>>>
>>> "Chris Keating(iAnywhere Solutions)"
>>> <NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com> wrote in message
>>> news:454fcc5a$1@forums-1-dub...
>>>> >>-Table partioning?
>>>>
>>>> AFAIK this is being considered.
>>>>
>>>> >>-What is the maximum memory hardware setting that SQL
>>>> >>Anywhere supports?
>>>>
>>>> The limits are OS specific. For Win2003 Server (32 bit), the limit is
>>>> 1.8 or 2.3 GBs for Enterprise/DataCenter. For AWE cache, 100% of
>>>> available memory. For 64 bit, limited by physical memory.
>>>>
>>>> >>-For optimal queries, is there a way to update schema
>>>> >>statistics?
>>>> I am still not following? SQL Anywhere updates statistics automatically
>>>> as queries are executed. You can also manually update statistics using
>>>> CREATE STATISTICS statement, if needed or required (a skew in the
>>>> statistics).
>>>>
>>>> >>Kjetley[Is reindexing supported for clustered indexes?]
>>>> You can REORGANIZE the index if the clustered index values are no
>>>> longer clustered.
>>>>
>>>> >>Kjetley[Can SQL Anywhere Studio support 500 GB databases or
>>>> >>is that better suited for SQL Server or Oracle, etc..?]
>>>> SQL Anywhere should be able to handle this volume of data without too
>>>> much difficulty assuming a reasonably well designed schema and
>>>> application architecture for those applications that interact with the
>>>> databaase. The real issue is the management of this database size i.e.,
>>>> backups, reloads, etc. SQL Anywhere 10 has a focus on improvements in
>>>> the management of larger databases.
>>>>
>>>>
>>>> --
>>>>
>>>> Chris Keating
>>>> Sybase Adaptive Server Anywhere Professional Version 8
>>>>
>>>> *****************************************************************************
>>>>
>>>> Sign up today for your copy of the SQL Anywhere Studio 9 Developer
>>>> Edition =and try out the market-leading database for mobile, embedded
>>>> and small to medium sized business environments for free!
>>>>
>>>> http://www.ianywhere.com/promos/deved/index.html
>>>>
>>>> *****************************************************************************
>>>>
>>>> iAnywhere Solutions http://www.iAnywhere.com
>>>>
>>>> ** Please only post to the newsgroup
>>>>
>>>> ** Whitepapers can be found at http://www.iAnywhere.com/developer
>>>> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
>>>> ** Use Case Express to report bugs http://case-express.sybase.com
>>>>
>>>> *****************************************************************************
>>>
>>>
>>
>>
>
>


Breck Carter [Team iAnywhere] Posted on 2006-11-09 14:58:00.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: SQL Anywhere 10.0 Features
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <ljj6l2htk1j91jd9apcnoalta6mc7uf67e@4ax.com>
References: <454f91f3$2@forums-1-dub> <454fa19f.1a78.1681692777@sybase.com> <454fcc5a$1@forums-1-dub> <45532bd9$1@forums-1-dub>
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: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 9 Nov 2006 07:58:00 -0700
X-Trace: forums-1-dub 1163087880 64.7.134.118 (9 Nov 2006 07:58:00 -0700)
X-Original-Trace: 9 Nov 2006 07:58:00 -0700, bcarter.sentex.ca
Lines: 14
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5717
Article PK: 1721

On 9 Nov 2006 05:23:37 -0700, "Gudjon Adalsteinsson"

<gudjon@fjarvirkni.is> wrote:

>(What does AFAIK mean?)

As far as I know


--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com