Re: 50 line queries (new flyer)

From: Peter Headland <Peter(at)matrixlink(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: 50 line queries (new flyer)
Date: 2009-03-03 23:32:56
Message-ID: 49ADBE28.7000203@matrixlink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy

Josh Berkus wrote:
> Peter Headland wrote:
>> Excuse my ignorance - I didn't understand the reference to 50-line
>> queries in the original version of the new flyer. I assume that
>> no-one thinks 50 lines of text is indicative of an especially complex
>> query, so what did that mean?
>
> Just *try* to run a 50-line query (with multiple subselects, etc.) on
> MySQL or SQLite.

Ah. I'm used to seeing queries with several hundred (long, dense, and
unreadable) lines that run just fine on Oracle, so the "50 lines" thing
made me wonder "if they think that's complex, maybe they can't handle
the really heavy stuff" - IOW, the opposite of what was intended.
Fortunately, that part is not in the final version of the document, so
it's moot.

I guess it's tricky to write a single document that hits all the right
notes with both the Oracle and MySQL crowds...

--
Peter Headland

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Douglas J Hunley 2009-03-04 02:38:39 pgsql announce now on twitter
Previous Message Josh Berkus 2009-03-02 19:35:23 Re: 50 line queries (new flyer)