One more thing. If you can create a true stored procedure in MS sql server.
and execute by passing in that would be faster ads well
Try this link
https://technet.microsoft.com/en-us/library/
It will show you transact sql server commands etc
On Thu, Sep 7, 2017 at 5:21 PM, Justin Will via 4D_Tech
Thanks Chuck, I'll give that a try. Perhaps batches of 25k records as arrays
will work and speed things up.
> You might try to use arrays to update and not individual records
Justin
**
4D Internet Users Group (4D iNUG)
FAQ: ht
> Le 7 sept. 2017 à 17:42, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> a
> écrit :
>
> I think this is what SQL EXPORT DATABASE and SQL EXPORT SELECTION do. You
> might have some issues with date/time fields as well as object fields.
Unfortunately these commands have been written in a 4d-
Jeffrey,
Thank you, I was not aware of SQL EXPORT DATABASE. I might be able to make it
work by dumping to an intermediate SQL database and then converting the data to
the slightly modified schema from there.
Thanks
Justin
**
Sure looks like it!
I wasn’t even aware of this command in 4D, but it calls it a ‘dump’, so that’s
the kind of text file I would expect this to create.
Randy
--
Randy Jaynes
Senior Programmer and Customer Support
http://printp
I think this is what SQL EXPORT DATABASE and SQL EXPORT SELECTION do. You
might have some issues with date/time fields as well as object fields.
--
Jeffrey Kain
jeffrey.k...@gmail.com
> On Sep 7, 2017, at 11:40 AM, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> Maybe you can
Maybe you can write 4D code to create blocks of insert statements in a text
file like
LOCK TABLES `CatalogPricing` WRITE;
INSERT INTO `CatalogPricing` (`catPriceID`, `catPriceCatalogID`, `catPriceQty`,
`catPriceAmount`, `catPriceStatus`)
VALUES
(2,2,1,15.00,'1'),
(7,3,1,15.00,'1
You might try to use arrays to update and not individual records
Regards
Chuck
Chuck Miller Voice: (617) 739-0306
Informed Solutions, Inc. Fax: (617) 232-1064
mailto:cjmillerinformed-solutio
8 matches
Mail list logo