Re: Web-based queries on large-ish tables - Matt Duggan - com.mysql.lists.mysql

10 messages in com.mysql.lists.mysqlRe: Web-based queries on large-ish ta...

From	Sent On	Attachments
Chai-Hup Chen	17 Jun 1999 09:33
Richard M. Neswold	17 Jun 1999 10:04
Graeme B. Davis	17 Jun 1999 10:13
Cooper Vertz	17 Jun 1999 10:53
Jason Brooke	05 Jul 1999 22:15
James Rogers	05 Jul 1999 23:31
Matt Duggan	06 Jul 1999 01:23
Tõnu Samuel	06 Jul 1999 01:27
Matt Duggan	06 Jul 1999 01:38
James Rogers	06 Jul 1999 10:44

Subject:	Re: Web-based queries on large-ish tables
From:	Matt Duggan (ma...@insnet.net)
Date:	07/06/1999 01:38:02 AM
List:	com.mysql.lists.mysql

Tõnu Samuel wrote:

Matt Duggan wrote:

What sort of amount of rows can MySQL handle comfortably??? Are we talking millions (i.e. the figure of 70 million was mentioned, is this with mysql?).

Yes it can but we spoken about web applications!

Web have own disadvantages. User requests for some page, waits for a second, then presses same button again. If there are many users simultaneously accessing some query which takes 2 seconds then the cumulative can quickly exceed minutes. This is principially Denial of service type of attack.

MySQL can handle big tables and do it efficiently. Try to compare this with other SQL-s. But don't try to do hundres of expensive requests at same time and expect to get your result below one second (web users assume this).

BTW. I hope this is secret I say but there is caching facility if coming in future. This must speed up many thigs related mostly to web-applications.

+---------------------------------------------------------------------+ | TcX ____ __ _____ _____ ___ | | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Tõnu Samuel | | /*/ /*/ /*/ \*\_ |*| |*||*| mailto: to...@mysql.com | | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Tallinn | | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Estonia | | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ | | /*/ \*\ Developers Team | +---------------------------------------------------------------------+

thanks for the reply...luckily our system is not open to the 'public' and only trained staff are using it, plus we have nice fast connections so latency isn't the problem it could be (it's even fine on ISDN!).

Matt.