Yes - performance is really important, in some cases - it all depends on what you do with a hit. On my P2-233 I have a database with some tables, two of those hold more then 800,000 records (each), and the others aren't all that far behind. several PHP pages that are hit by almost anyone seeing the site do some interesting order-by, group-by select queries - resulting in one of the page's load time being just shy of 25 seconds (!! and that's as optimised as I could make it - it used to be around a minute and a half). this is unacceptable, and tests have shown that using a modern computer I can reduce that to under a second. It remains interesting to see how PostgreSQL will handle _that_ load : regardless of hit count or concurrent connections - a web page shouldn't take 30 seconds to load.
-- "If you crush everything in your path to the top, what will there be left for you to rule over?" -- Matthew Wallace ----- Original Message ----- From: "Ben-Nes Michael" <[EMAIL PROTECTED]> To: "Oded Arbel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, November 22, 2001 10:01 AM Subject: Re: Open a table directly in MySql > some of my thought about performance. > Is it really important ? > > Well in out little country I don't think so, lets imagine a site that get > 5,000,000 ( big site in any meaning - a good site for my opinion get 100,000 > hits per month) > 5,000,000 hits are equals to 2 queries per second which is easy task to my > P-300 with 512MB mem that's run many thing simultaneously (MySQL, > Postgresql, Apache .... ) > > In db the most important thing is Integrity and not the performance, and any > way if I had a site that get 5,000,000 hits I could easily upgrade the web > server to a real canon. > > -------------------------- > Canaan Surfing Ltd. > Internet Service Providers > Ben-Nes Michael - Manager > Tel: 972-4-6991122 > http://sites.canaan.co.il > -------------------------- > > ----- Original Message ----- > From: "Oded Arbel" <[EMAIL PROTECTED]> > To: "Ben-Nes Michael" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Wednesday, November 21, 2001 10:32 PM > Subject: Re: Open a table directly in MySql > > > > Like I said - there opinions and facts going any which way, but as far as > > I've seen, all benchmarks that can be reproduced in stable environments > show > > the mySQL lead to be quite big on simple queries. now - since mySQL > doesn't > > handle complex quries - badly or not at all (at least until 4.1), you'll > > just have to ask yourself if you need complex quries : if you do, then the > > answer is obvious - and benchmarking has nothing to do with it. > > > > as for the MySQL AB team's response to the Tim Perdue article, read this : > > http://www.mysql.com/doc/M/y/MySQL-PostgreSQL_benchmarks.html . about two > > thirds down. > > > > then there's this : > > http://acidlab.sourceforge.net/perf/acid_perf.html > > > > -- > > It's the constant and determined effort that breaks down resistance, > sweeps > > away all obstacles. > > --Claude M. Bristol > > > > > > ================================================================= > To unsubscribe, send mail to [EMAIL PROTECTED] with > the word "unsubscribe" in the message body, e.g., run the command > echo unsubscribe | mail [EMAIL PROTECTED] > > ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
