Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is anyone experiencing the limited loads not working for them (the check box on the debug screen)? I only wanted to load 1000 lines and the database read is climbing over 240k right now.
Just curious to whether or not anyone is experiencing this lately.
Hello Scott,
What version are you using? Is that happening with a hidden script? Does that happen to all your files? Are you performing a binary load?
Regards.
BI Consultant
QV v10 and its happening with the regular script. It worked before and I guess I havent used it in a while.
Also - This is going against DB2 tables, so I added "FETCH ONLY n ROWS;" to my queries to resolve it.
Hi,
Sounds strange indeed, and I haven't noticed that behavior. I haven't tested with SR3 of v10 though. Is there any chance that the driver has been modified, updated or something?
Although I think your way is the fastest, you can give a try to either
Table:
FIRST 10000 LOAD *; // or use a variable instead
SQL SELECT ...;
or
Table:
LOAD *
WHERE RecNo() < 10001; // a variable will work as well
SQL SELECT ...;
I think yours is faster because the LOAD is pulling all records from database, but loading only those that match the condition.
Hope that helps.
BI Consultant
Yes this is happening to us too. We are running QV 10.00.8935.0409.
Yes this is happening to us too. We are running QV 10.00.8935.0409.