Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #28543

Re: Python Interview Questions

Show key headers only | View raw

On Thu, Sep 6, 2012 at 2:40 AM, Ian Kelly <ian.g.kelly@gmail.com> wrote:
> On Wed, Sep 5, 2012 at 9:34 AM, Chris Angelico <rosuav@gmail.com> wrote:
>> On Thu, Sep 6, 2012 at 1:22 AM, Ian Kelly <ian.g.kelly@gmail.com> wrote:
>>> The lack of an ORDER BY is the least of the problems with that SQL.
>>> He's also using LIMIT without OFFSET, so the only thing that the
>>> 'item' argument changes is how many rows are returned (all but one of
>>> which are ignored), not which one is actually fetched.
>>
>> No, he's using the two-arg form of LIMIT.
>
> My mistake.  I didn't even know there was a two-arg form of LIMIT.
> Must be a MySQL thing. :-)

Yeah, it's not something I've used, but when my current job started,
we were using MySQL and I used to eyeball the logs to see what queries
were performing most suboptimally. (There were some pretty egregious
ones. Most memorable was rewriting a TEXT field several times a second
with several KB of PHP serialized array with status/statistical
information. Structured information, yes. Stored as a clob.) My first
databasing experience was DB2, with the uber-verbose "FETCH FIRST n
ROW[S] ONLY", but now I'm happily on Postgres.

Everyone who wants to use LIMIT without ORDER BY should try their code
on Postgres. You'll quickly discover the problem.

ChrisA

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Re: Python Interview Questions charvigroups@gmail.com - 2012-09-04 23:50 -0700
  Re: Python Interview Questions Kushal Kumaran <kushal.kumaran+python@gmail.com> - 2012-09-05 14:10 +0530
  Re: Python Interview Questions Peter Otten <__peter__@web.de> - 2012-09-05 16:21 +0200
  Re: Python Interview Questions Chris Angelico <rosuav@gmail.com> - 2012-09-06 00:34 +1000
  Re: Python Interview Questions Chris Angelico <rosuav@gmail.com> - 2012-09-06 00:36 +1000
  Re: Python Interview Questions Ian Kelly <ian.g.kelly@gmail.com> - 2012-09-05 09:22 -0600
    Re: Python Interview Questions Roy Smith <roy@panix.com> - 2012-09-05 12:38 -0400
  Re: Python Interview Questions Chris Angelico <rosuav@gmail.com> - 2012-09-06 01:34 +1000
  Re: Python Interview Questions Dave Angel <d@davea.name> - 2012-09-05 12:01 -0400
  Re: Python Interview Questions Roy Smith <roy@panix.com> - 2012-09-05 12:11 -0400
  Re: Python Interview Questions Ian Kelly <ian.g.kelly@gmail.com> - 2012-09-05 10:40 -0600
    Re: Python Interview Questions Roy Smith <roy@panix.com> - 2012-09-05 12:45 -0400
  Re: Python Interview Questions Chris Angelico <rosuav@gmail.com> - 2012-09-06 08:13 +1000
  Re: Python Interview Questions Kushal Kumaran <kushal.kumaran+python@gmail.com> - 2012-09-06 09:54 +0530
  Re: Python Interview Questions MRAB <python@mrabarnett.plus.com> - 2012-09-06 12:38 +0100

csiph-web