Hmm, am o tabela cu carti cu 1453534 de inregistrari,
iar cea cu cuvintele din tiluri si autori mi'a ajuns la 8290518:
select rec_id,sum(length(word)) as score,
half.name,half.creator,half.isbn,half.medium
from words_book
left join half on half.release_id=rec_id
where (word = 'dune' or word = 'mesiah')
and whereis=0
group by rec_id order by score desc,half.name
limit 0,20
-> ;
+------------+-------+------------------------------------------------------
----------------------------------- -------------+---------
-------------------------+------------+-----------+
| rec_id | score | name
| creator | isbn | medium |
+------------+-------+------------------------------------------------------
----------------------------------- -------------+---------
-------------------------+------------+-----------+
| 286170 | 4 | A Dune Buggy Ride with Baby Taz
[...]
Herbert | 0606031111 | Other |
| 3549648 | 4 | Dune
| Frank Herbert | 0801950775 | Hardcover |
+------------+-------+------------------------------------------------------
------------------------------------------------+---------------------------
-------+------------+-----------+
20 rows in set (0.01 sec)
Totul tine de cum iti indexezi tabelele.
Marius
----- Original Message -----
From: "Mircea MITU" <[EMAIL PROTECTED]>
To: "rlug" <[EMAIL PROTECTED]>
Sent: Thursday, November 01, 2001 3:15 PM
Subject: [rlug] Re: postgresql vs mysql
>
> On Thu, 2001-11-01 at 15:17, Sebastian Paul Avarvarei wrote:
> > Oricum, pana la urma cel mai important e sa folosesti scula potrivita.
> > Am lucrat destul de mult cu MySQL pt aplicatii Web, cu tabele de mii si
> > zeci de mii de inregistrari, si pot sa spun ca "zbarnaie".
>
> corect, zbarnaitu devine harait d'abia de la 100.000 incolo
> (si atunci, ofc, depinde de interogari)
>
>
> ---
> Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to
> unsubscribe from this list.
>
>
---
Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to
unsubscribe from this list.
