Nu jei kazko labai daug, tai pavizdys pvz. facebook: 

Facebook is now running 10,000 servers, including 1,800 MySQL servers  
http://sqlblog.com/blogs/denis_gobo/archive/2008/04/24/6379.aspx 

Kaip matai dideli webai net tukstanciais serveriu siekia, dar cia nepamineti cache serveriai kuriuos ir naudoja fb ;)


"ramunas" <doobas@gmail.com> wrote in message news:itnjr7$cjl$1@trimpas.omnitel.net...
> kas yra PK ? :) ir siaip esme tame, kad noriu zhinoti ar uzims dakuja laiko 
> ir apkraus smarkiai procesoriu. tada hostintojas sakys WTF. ir ar reikia 
> galvoti kita iseiti dideliam kiekiui duomenu :)
> 
> "Dainius" <dainius@something.com> wrote in message 
> news:itnfgl$6as$1@trimpas.omnitel.net...
>> ir jokio skirtumo ar tai
>> select * from t where id = 1
>> ar select * from t cross join t1 cross join t2 where t.id = 1
>>
>> On 06/20/2011 01:39 PM, Jornada Del Muerto wrote:
>>> Teoriskai tai nuo daug ko priklausyt gali, pvz.:
>>>
>>> 1. Ant kiek dideli lentos irasai;
>>> 2. Ant kiek greitas HDD, reiciau veiks su ivairiais raid 5 greiciausia 
>>> :);
>>> 3. Ant kiek isfragmentuotas diskas (kada daryta defragmentacija);
>>> 4. Ant kiek greitas kompas :)
>>> 5. Kokia kita servo pastovi apkrova be tos uzklausos...
>>>
>>> Cia aisku taip is lempos ir pusiau rimtai... :) pajami ir pratestini ir 
>>> viskas.... svarbu indeksas ar PK butu ant lauko per kuri ieskoma...
>>>
>>> "Dainius"<dainius@something.com>  wrote in message 
>>> news:itmpm2$4qn$1@trimpas.omnitel.net...
>>>> lol
>>>> bet tikriausiai i toki klausima geresnio atsakymo nelabai ir sugalvosi.
>>>>
>>>> On 06/19/2011 12:50 PM, Jornada Del Muerto wrote:
>>>>> Nu jei ten tas ID PK, neturetu ilgai vykt.
>>>>>
>>>>> "ramunas"<doobas@gmail.com>   wrote in message 
>>>>> news:itkdaj$2lt$1@trimpas.omnitel.net...
>>>>>> na paprasta uzklausa ... is ~300000 eiluciu surasti viena unikalia 
>>>>>> eilute,
>>>>>> kurios pvz. ID = 234879. ir istraukti is tos eilutes visus joje 
>>>>>> esancius
>>>>>> duomenis.
>>>>>>
>>>>>>
>>>>>>
>>>>>> "Artūras Šlajus"<x11@arturaz.net>   wrote in message
>>>>>> news:itkbra$135$1@trimpas.omnitel.net...
>>>>>>> On 06/19/2011 10:56 AM, ramunas wrote:
>>>>>>>> kiek +- laiko truks mysql uzklausa jei eiluciu bus ~300 000 ?
>>>>>>>>
>>>>>>>>
>>>>>>> 1-10000000000ms
>>>>>>>
>>>>>>> Priklauso nuo užklausos.
>>>>>>>
>>>>>>> __________ Information from ESET NOD32 Antivirus, version of virus
>>>>>>> signature database 6220 (20110618) __________
>>>>>>>
>>>>>>> The message was checked by ESET NOD32 Antivirus.
>>>>>>>
>>>>>>> http://www.eset.com
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>
>>
>>
>> __________ Information from ESET NOD32 Antivirus, version of virus 
>> signature database 6223 (20110620) __________
>>
>> The message was checked by ESET NOD32 Antivirus.
>>
>> http://www.eset.com
>>
>>
>> 
> 
>