Обсуждение: 50 line queries (new flyer)

Поиск
Список
Период
Сортировка

50 line queries (new flyer)

От
Peter Headland
Дата:
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?

-- 
Peter Headland

Re: 50 line queries (new flyer)

От
Josh Berkus
Дата:
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.

--Josh



Re: 50 line queries (new flyer)

От
Peter Headland
Дата:
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