Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
seems to be Incremental load will helps here.
Hi,
I think it wont take exactly Y * 100 seconds, may be we can get in very less time then expected.
Regards,
Jagan.