|
On Mar 1, 2022, at 9:59 AM, Denis Robitaille <denis_robitaille@xxxxxxxxxxxx> wrote:--
Hello all,
I am currently working on a complex (for me) SQL script. When I run it to display the result on the screen, it works fine. When I change it to put the result of the SELECT in a file (by inserting the appropriate INSERT INTO... before the SELECT), it takes more that 10 times longer to execute!!
I am working with a small subset of data and the resulting data set is just 51 rows.
Any help on understanding this behavior and on how to avoid it is very appreciated.
[cid:image001.png@01D82D5A.F658C930]<http://www.cascades.com/fr>
Denis Robitaille
Analyste TI
CASCADES CANADA ULC
412 Boul. Marie-Victorin
Kingsey Falls (QC) Canada J0A 1B0
Tél. : 819 363 6100 Poste : 52130
Cell. : 819 352 9362
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit:
https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist
s.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=04%7C01%7Cde
nis_robitaille%40cascades.com%7Ca2b85050f6304c58aeba08d9fba1a79a%7Ca86
6874ad0e34a03a79d4c893ab51296%7C0%7C0%7C637817493991647296%7CUnknown%7
CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXV
CI6Mn0%3D%7C3000&sdata=jxXEQ3dzf7xatnEOXvWLnXxLG8UMuES%2BcqV4ZQuHf
Q4%3D&reserved=0 or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fmidrange-l&data=04%7C01%7Cdenis_robitaille%40cascades.com%7Ca2b85050f6304c58aeba08d9fba1a79a%7Ca866874ad0e34a03a79d4c893ab51296%7C0%7C0%7C637817493991647296%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=LFX%2BbUavOa2eLP4XbWw050WRz2fdfnTcG5DyupdkCbk%3D&reserved=0.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Famaz
on.midrange.com%2F&data=04%7C01%7Cdenis_robitaille%40cascades.com%
7Ca2b85050f6304c58aeba08d9fba1a79a%7Ca866874ad0e34a03a79d4c893ab51296%
7C0%7C0%7C637817493991647296%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwM
DAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=Jeg
HUvSthdNdY%2FO7BDsVx7c7wo6803GVVxeArwLD57M%3D&reserved=0
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.