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

Re: Odbc and client library/drivers

Newsgroups	comp.databases.ms-sqlserver
Date	2012-09-21 03:14 -0700
References	(6 earlier) <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>
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>

Show all headers | 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