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.

Table with many columns

4 posts in General Discussion Last posting was on 2011-06-01 15:12:15.0Z
RGS Posted on 2011-05-31 21:23:30.0Z
Sender: 1bdb.4de4fd42.1804289383@sybase.com
From: RGS
Newsgroups: sybase.public.ase.general
Subject: Table with many columns
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4de55c52.266c.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 31 May 2011 14:23:30 -0700
X-Trace: forums-1-dub 1306877010 10.22.241.41 (31 May 2011 14:23:30 -0700)
X-Original-Trace: 31 May 2011 14:23:30 -0700, 10.22.241.41
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30206
Article PK: 72386

Hi!

I have a table with many columns (100). Each record of the
table takes 20Kbytes

I heard that I can change some property (size of the
pool?...)of the table for execute faster the SELECT command
on the table.

What is this property? If I change it, there will be a
problem with another operations?

Thanks!


Bret Halford Posted on 2011-05-31 22:12:21.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.17) Gecko/20110414 Thunderbird/3.1.10
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Table with many columns
References: <4de55c52.266c.1681692777@sybase.com>
In-Reply-To: <4de55c52.266c.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: <4de567c5$1@forums-1-dub>
Date: 31 May 2011 15:12:21 -0700
X-Trace: forums-1-dub 1306879941 10.22.241.152 (31 May 2011 15:12:21 -0700)
X-Original-Trace: 31 May 2011 15:12:21 -0700, vip152.sybase.com
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30207
Article PK: 72385


On 5/31/2011 3:23 PM, RGS wrote:
> Hi!
>
> I have a table with many columns (100). Each record of the
> table takes 20Kbytes
>
> I heard that I can change some property (size of the
> pool?...)of the table for execute faster the SELECT command
> on the table.
>
> What is this property? If I change it, there will be a
> problem with another operations?
>
> Thanks!

I suspect you may have posted in a newsgroup for the wrong
product. The widest row possible in ASE is a bit under 16K
(on a server using a 16k page size). What product are
you actually using?


RGS Posted on 2011-05-31 22:29:25.0Z
Sender: 1bdb.4de4fd42.1804289383@sybase.com
From: RGS
Newsgroups: sybase.public.ase.general
Subject: Re: Table with many columns
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4de56bc5.2809.1681692777@sybase.com>
References: <4de567c5$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 31 May 2011 15:29:25 -0700
X-Trace: forums-1-dub 1306880965 10.22.241.41 (31 May 2011 15:29:25 -0700)
X-Original-Trace: 31 May 2011 15:29:25 -0700, 10.22.241.41
Lines: 26
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30208
Article PK: 72387

I am so sorry

The correct size is 12 Kbytes

I am using ASE 15.0.3

> On 5/31/2011 3:23 PM, RGS wrote:
> > Hi!
> >
> > I have a table with many columns (100). Each record of
> > the table takes 20Kbytes
> >
> > I heard that I can change some property (size of the
> > pool?...)of the table for execute faster the SELECT
> > command on the table.
> >
> > What is this property? If I change it, there will be a
> > problem with another operations?
> >
> > Thanks!
>
> I suspect you may have posted in a newsgroup for the wrong
> product. The widest row possible in ASE is a bit under
> 16K (on a server using a 16k page size). What product are
> you actually using?


Bret Halford Posted on 2011-06-01 15:12:15.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.17) Gecko/20110414 Thunderbird/3.1.10
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Table with many columns
References: <4de567c5$1@forums-1-dub> <4de56bc5.2809.1681692777@sybase.com>
In-Reply-To: <4de56bc5.2809.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: <4de656cf$1@forums-1-dub>
Date: 1 Jun 2011 08:12:15 -0700
X-Trace: forums-1-dub 1306941135 10.22.241.152 (1 Jun 2011 08:12:15 -0700)
X-Original-Trace: 1 Jun 2011 08:12:15 -0700, vip152.sybase.com
Lines: 54
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30210
Article PK: 72389

Ok, thanks for confirming.

Offhand, I can't think of any specifically table-level
configurations that might make a difference.

What does come to mind is

1) asynchronous prefetch (get the pages to be accessed by
the select into cache before the spid actually scans them, avoiding
waits for physical i/o)

2) binding the table to a named cache large enough to hold
the table (keep those pages in memory)

3) If regularly selecting a subset of the columns that is
smaller than 600 bytes in total width, create an index on
those columns so a "covered index scan" can be done that
gets all the data from the leaf level of the index rather than
having to read the full data pages

-bret

On 5/31/2011 4:29 PM, RGS wrote:
> I am so sorry
>
> The correct size is 12 Kbytes
>
> I am using ASE 15.0.3
>
>
>> On 5/31/2011 3:23 PM, RGS wrote:
>>> Hi!
>>>
>>> I have a table with many columns (100). Each record of
>>> the table takes 20Kbytes
>>>
>>> I heard that I can change some property (size of the
>>> pool?...)of the table for execute faster the SELECT
>>> command on the table.
>>>
>>> What is this property? If I change it, there will be a
>>> problem with another operations?
>>>
>>> Thanks!
>>
>> I suspect you may have posted in a newsgroup for the wrong
>> product. The widest row possible in ASE is a bit under
>> 16K (on a server using a 16k page size). What product are
>> you actually using?