t; <[EMAIL PROTECTED]>
To: "mySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 4:35 PM
Subject: Re: Large fields vs. performance
> > Could be just parania. Several time a second is not much. My guess
> > is that you'll be fine. If it gets
>
> > Could be just parania. Several time a second is not much. My guess
> > is that you'll be fine. If it gets slower upgrade your hardware or
> > reconfigure your OS or/and FS or/and MySQL. Anyway, my string
> > opinion is that you should split the table. As i said before that
> > we've
> > been
> Could be just parania. Several time a second is not much. My guess
> is that you'll be fine. If it gets slower upgrade your hardware or
> reconfigure your OS or/and FS or/and MySQL. Anyway, my string
> opinion is that you should split the table. As i said before that
> we've
> been doing for yea
>
> > René Tegel wrote:
> > >
> > > This is a very good idea, and in fact the only workable way.
> > > Your performance will not lower when retrieving the documents,
> cause those
> > > fields are indexed.
> > > Your memory use will decrease as well, since the file cache does
> not have to
> > >
> René Tegel wrote:
> >
> > This is a very good idea, and in fact the only workable way.
> > Your performance will not lower when retrieving the documents,
cause those
> > fields are indexed.
> > Your memory use will decrease as well, since the file cache does
not have to
> > cache a big table whe
René Tegel wrote:
>
> This is a very good idea, and in fact the only workable way.
> Your performance will not lower when retrieving the documents, cause those
> fields are indexed.
> Your memory use will decrease as well, since the file cache does not have to
> cache a big table when searching.
I am not good at DB theory, but in our practice
(SQL DB development form WEB since 97) splitting
a table to get recrods to be fixed length is always
beneficial when table is in haavy use. You can get fast
lookups and just a bit slower inserts, but since, inserts
are usually much rare compared to s
