Re: performance question

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1080112836.66590_at_yasure...
> Alex wrote:
>
> > Hi,
> >
> > I have a situation where any design or other suggestions are
appreciated.
> >
> > I have more than half a million data files with 300K each. Each file is
one
> > record with a binary data section of around 7K that I am interested in.
I'll
> > need to do query on that particular binary data section in that huge
table
> > of data record, such as 'SELECT * FROM MyHugeTable WHERE
> > ColumnName='MyBinaryColumn'. Are there suggestions (table design, query
and
> > others) that may help to improve the performance?
> >
> > Thanks a lot,
> >
> > Alex
>
> Unless I have completely misunderstood you ... you have more than
> 500,000 data files? Each sized at 300K? And each with a single record?

Since you can't have more than 65000-odd files in a database, I doubt this is what he actually means. I think he means he has half a million records, each 300K in length, and he wants to access just 7K of long raw or blob from within said records.

Regards
HJR
> And I thought the people I went to school with in the 60s were doing
> drugs. ;-) Are you serious? Why?
>
> How would I improve performance? Put it all into a far smaller number
> of datafiles for starters.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Wed Mar 24 2004 - 01:43:32 CST