topic Re: Help me in below scenario? in QlikView

Help me in below scenario?

durgabhavani — Mon, 25 May 2015 09:00:44 GMT

Hi All,

I have 7000 number of records in my database.
Suppose i want to upload x number of updates(records), it took y number or seconds.
So on average we expect x number of updated rows to be pulled in y seconds.

Now I need to find out what happens if the number of records multiply by 100,500,1000...

Can i simulate pulling that many records without having them in database?

This is higly appreciated.

Thanks,
Durga

Re: Help me in below scenario?

Gysbert_Wassenaar — Mon, 25 May 2015 09:12:42 GMT

Yes, you can use the Autogenerate function to generate rows. To load every record a 100 times you do something like this:

MyData:

LOAD * FROM MyDataBaseTable

Autogenerate 100;

Re: Help me in below scenario?

buzzy996 — Mon, 25 May 2015 09:14:58 GMT

seems to be Incremental load will helps here.

Re: Help me in below scenario?

jagan — Mon, 25 May 2015 09:28:10 GMT

Hi,

I think it wont take exactly Y * 100 seconds, may be we can get in very less time then expected.

Regards,

Jagan.