replace with
Selection to array?
On Thu, 20 Oct 2016 16:57:26 -0400, Charles Miller wrote:
> Given the following code
>
> ARRAY TEXT(BMSBIN;0)
> ARRAY LONGINT(BMSInspID;0)
> ARRAY DATE(BMSInspDate;0)
> ARRAY TEXT(BMSInspType;0)
> ARRAY LONGINT(BmsNBEID;0)
> ARRAY BOOLEAN(BmsComplete;0)
> ARRAY LONGINT(BmsReviewed;0)
> ARRAY LONGINT(BmsApproved;0)
> ARRAY LONGINT(BMSBMSInspID;0)
>
> SQL LOGIN("IP:146.243.135.242:19812";"designer";"caesar";*)
>
> If (OK=1)
>
> $startTick_L:=Tickcount
> Begin SQL
> select
>
> [Inspections].BIN
> , [Inspections].InspID
> , [Inspections].[Insp Date]
> , [Inspections].[Insp Type]
> , [Inspections].InspComplete
> , [Inspections].InspReviewed
> , [Inspections].InspApproved
> from [inspections]
>
> into
> :BMSBIN
> , :BMSInspID
> , :BMSInspDate
> , :BMSInspType
> , :BmsComplete
> , :BmsReviewed
> , :BmsApproved
>
> ;
>
> End SQL
>
> $EndTick_L:=Tickcount
>
> SQL LOGOUT
>
> When run from a VM (on a MAC have tried VMWare and Parallels). The select
> never finishes
>
> When run from a VM (windows 7 on same VMWare and Parallels). The select
> finishes in about 30 seconds.
>
> We are retrieving about 80,000 rows
>
> I know this is v11 but any ideas appreciated. Additionally clearing the
> arrays take some amount of time
>
> Regards
>
> Chuck
> --
>
-----------------------------------------------------------------------------------------
> Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
> Informed Solutions, Inc.
> Brookline, MA 02446 USA Registered 4D Developer
> Providers of 4D, Sybase & SQL Sever connectivity
> http://www.informed-solutions.com
>
-----------------------------------------------------------------------------------------
> This message and any attached documents contain information which may be
> confidential, subject to privilege or exempt from disclosure under
> applicable law. These materials are intended only for the use of the
> intended recipient. If you are not the intended recipient of this
> transmission, you are hereby notified that any distribution, disclosure,
> printing, copying, storage, modification or the taking of any action in
> reliance upon this transmission is strictly prohibited. Delivery of this
> message to any person other than the intended recipient shall not
> compromise or waive such confidentiality, privilege or exemption
> from disclosure as to this communication.
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> FAQ: http://lists.4d.com/faqnug.html
> Archive: http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub: mailto:[email protected]
> **********************************************************************
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
