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> <4486daa1-575b-4713-9ca5-f4c8654eb9c8@googlegroups.com> <3fe97e67-bae3-423e-9a1d-bdb938e48e7d@googlegroups.com> <50cb24ed-7b00-4bd1-9de3-dc00553ea2bb@googlegroups.com> <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> Subject: Re: Odbc and client library/drivers From: =?ISO-8859-1?Q?bj=F6rn_lundin?= 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 Den fredagen den 21:e september 2012 kl. 12:10:54 UTC+2 skrev bj=F6rn lundi= n: >=20 > 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. =20 -- Bj=F6rn Lundin