Help me in below scenario?

[durgabhavani]

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

[Gysbert_Wassenaar]

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;

[buzzy996]

seems to be Incremental load will helps here.

[jagan]

Hi,

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

Regards,

Jagan.