Groups > comp.databases.ms-sqlserver > #1316

Re: Odbc and client library/drivers

Received	by 10.224.70.131 with SMTP id d3mr273911qaj.0.1348222457056; Fri, 21 Sep 2012 03:14:17 -0700 (PDT)
Received	by 10.52.75.36 with SMTP id z4mr745696vdv.14.1348222457033; Fri, 21 Sep 2012 03:14:17 -0700 (PDT)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!l8no2498306qao.0!news-out.google.com!e10ni833245qan.0!nntp.google.com!l8no2460269qao.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Fri, 21 Sep 2012 03:14:16 -0700 (PDT)
In-Reply-To	<6a38c299-ecef-479d-bcc2-d05d1e19546c@googlegroups.com>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=83.145.50.10; posting-account=3_reEwoAAAC163IAIrx427KYmwahFuh9
NNTP-Posting-Host	83.145.50.10
References	<94298aed-7cbb-41f8-a155-c4632fc9db35@googlegroups.com> <XnsA0D2DF54CB785Yazorman@127.0.0.1> <4486daa1-575b-4713-9ca5-f4c8654eb9c8@googlegroups.com> <XnsA0D3D87BB2DB5Yazorman@127.0.0.1> <3fe97e67-bae3-423e-9a1d-bdb938e48e7d@googlegroups.com> <XnsA0D3F197028B1Yazorman@127.0.0.1> <50cb24ed-7b00-4bd1-9de3-dc00553ea2bb@googlegroups.com> <XnsA0D4EF4453665Yazorman@127.0.0.1> <11c929ed-7994-4ef8-87af-5989e567bd01@googlegroups.com> <2bcb8b31-a822-4ce0-a97e-bd95aadd3588@googlegroups.com> <6a38c299-ecef-479d-bcc2-d05d1e19546c@googlegroups.com>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<5491656a-33bf-43cf-a0a5-428fae3b8b8b@googlegroups.com> (permalink)
Subject	Re: Odbc and client library/drivers
From	björn lundin <b.f.lundin@gmail.com>
Injection-Date	Fri, 21 Sep 2012 10:14:17 +0000
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	quoted-printable
Xref	csiph.com comp.databases.ms-sqlserver:1316

Show key headers only | View raw

Den fredagen den 21:e september 2012 kl. 12:10:54 UTC+2 skrev björn lundin:
> 
> We READ all columns into structs but that does not
> mean the code is looping over all fields, _treating_ them.

On a performance note:
This is a WMS/WCS system. The main goal is to create assignments
to move pallets around in a warehouse.

Taking 10/100/1000 ms more to read all columns is a small part of
the total time the assignment lives.
Fork lifts, stacker cranes, conveyor systems all takes minutes
in comparison.


 
--
 Björn Lundin

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-18 10:48 -0700
  Re: Odbc and client library/drivers Erland Sommarskog <esquel@sommarskog.se> - 2012-09-18 21:57 +0200
    Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-18 13:24 -0700
      Re: Odbc and client library/drivers George Neuner <gneuner2@comcast.net> - 2012-09-19 11:46 -0400
      Re: Odbc and client library/drivers Erland Sommarskog <esquel@sommarskog.se> - 2012-09-19 21:16 +0200
        Re: Odbc and client library/drivers Gene Wirchenko <genew@ocis.net> - 2012-09-19 13:14 -0700
          Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-19 13:41 -0700
            Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-19 13:45 -0700
              Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-19 13:56 -0700
                Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-19 14:00 -0700
        Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-19 13:26 -0700
          Re: Odbc and client library/drivers Erland Sommarskog <esquel@sommarskog.se> - 2012-09-19 23:44 +0200
            Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-20 01:50 -0700
              Re: Odbc and client library/drivers Erland Sommarskog <esquel@sommarskog.se> - 2012-09-20 23:31 +0200
                Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-21 01:18 -0700
                Re: Odbc and client library/drivers bradbury9 <ray.bradbury9@gmail.com> - 2012-09-21 02:57 -0700
                Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-21 03:10 -0700
                Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-21 03:14 -0700
  Re: Odbc and client library/drivers rja.carnegie@gmail.com - 2012-09-19 16:57 -0700
    Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-20 01:58 -0700

csiph-web