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.
Thank you (both) for your quick answers.
I guess I will do the split, thanks to you!
But perhaps I didn't manage to express my biggest worry correctly:
With one table, I do one INSERT. Now I will have to do two
INSERTs for each new entry. If I INSERT several times a second,
I am afraid of troubles caused by doubling the number of INSERTs.
Paranoia?
--
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
