Damn it! Split it now or never, already!
You need to create some kind of numeric unique id for
each record and do left join for them.
SELECT * FROM table1 LEFT JOIN table2 WHERE table1.id=table2.id
And don't forget to create appropriate indices (UNIQUE index on id at
least
in each table)
It is all application dependent, if you need to most select all data
except the text field, then you'll win a lot, if you need to select
the
text field all the time then why bother with split in the first place?
Artem Koutchine
----- Original Message -----
From: "Torkil Grindstein" <[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 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 years now (keep all blob, text fields in separate
> > tables).
> > For me it is a strict rule by now.
> >
> > Split it!
>
> I'm about to.
>
> But....:)
>
> What it critical for the application is fast selection from all
> fields, including the document field. I have now made a copy of
> the entire database, where I did the split on the copy.
>
> SELECT * FROM main LIMIT 10000,100
> on the original db took approx 28 seconds.
>
> SELECT m.url, ..., FROM main m, doc d WHERE m.url=d.url LIMIT
10000,100
> on the splitted database took 40 secs. (the ... stands for all
> attribute names in main)
>
> So I'm afraid of the loss when the database reaches a million
> rows.
>
> (SELECTS without the document is significantly faster (from 50
> seconds to .2 seconds), but these queries are not that critical
> for the application.)
> --
> Torkil Grindstein Mail: [EMAIL PROTECTED]
> System Architect Web: http://www.fast.no
> Fast Search & Transfer ASA Phone: +47 21 60 11 90
> Grønnegata 80, Pb 571 Fax: +47 77 69 66 89
> NO-9261 Tromsø, NORWAY Mob: +47 98 06 61 38
>
> Try FAST Search: http://www.alltheweb.com
>
> --------------------------------------------------------------------
-
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
