topic Re: Limited Loads not working? in QlikView

Limited Loads not working?

Tue, 05 Jul 2011 17:13:52 GMT

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.

Re: Limited Loads not working?

Miguel_Angel_Baeyens — Tue, 05 Jul 2011 17:21:19 GMT

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.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Limited Loads not working?

Tue, 05 Jul 2011 17:23:41 GMT

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.

Re: Limited Loads not working?

Miguel_Angel_Baeyens — Tue, 05 Jul 2011 17:31:59 GMT

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 ...;

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.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Limited Loads not working?

Wed, 16 Jan 2013 22:02:42 GMT

Yes this is happening to us too. We are running QV 10.00.8935.0409.

Re: Limited Loads not working?

Wed, 16 Jan 2013 22:02:47 GMT

Yes this is happening to us too. We are running QV 10.00.8935.0409.