Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one extractor which is used to create the Qvd's and those are used in the applications.
I want to create a separate application to show the below calculations to the user .
This will helpful to developer at which step the application is taking more time to reload.
Need Start time of sales
Sales:
Load * from sales;
Store Sales into D:\Sales.qvd;
Need End time of Sales
Need Start time of Products
Products:
Load * from products;
Store Products into D:\Products.qvd;
Need End time of Products
Need Start time of Mutual
Mutual:
Load Id,Product resident Products;
Drop table Products;
Need End time of Mutual
Drop table sales; (Need Time)
Drop table Products; (Need Time)
I hope you guys understand my requirement.
More Thanks,
Ajay
Hi Ajay,
Let assume this simple load
LET vStartSales = Now();
Sales:
LOAD
Rand() as Sales
AutoGenerate 5200000;
LET vEndSales = now();
LET vStartProduct = Now();
Products:
LOAD
Rand() as Product
AutoGenerate 5200000;
LET vEndProduct = Now();
LET vStartMutual = Now();
Mutual:
LOAD
Rand() as Mutual
AutoGenerate 5200000;
LET vEndMutual = Now();
And after this you get values in the variables by plot them in the text object.
Regards
Anand
Hi,
Create the variables in the load script
LET vStartSales = Now();
Sales:
Load * from sales;
Store Sales into D:\Sales.qvd;
LET vEndSales = Now();
LET vStartProduct = Now();
Products:
Load * from products;
Store Products into D:\Products.qvd;
LET vEndProduct = Now();
LET vStartMutual = Now();
Mutual:
Load Id,Product resident Products;
Drop table Products;
LET vEndMutual = Now();
LET vSalesDel = Now();
Drop table sales;
LET vProductDel = Now();
Drop table Products;
And take this variables for the information.
Let me know if not works
Regards
Anand
Thanks Anand.But its giving both start time and end time as same.
Thanks,
Ajay
Hi Ajay,
Anand's Solution definately working.
Please see below screen shots:
Regards
Neetha
Thanks Neetha.
could you please correct me if am wrong.
let vstarttime =now();
t1:
load * inline [product,amount,place
A,100,iND
B,200,US
C,300,UK
D,400,SWEDEN
E,500,NORWAY];
store t1 into D:\Testing_QV\RES5.QVD;
let vendtime =now();
Note : if am adding this "LET" function to the my script then it will not increase the reload time of application...right?
Hi Ajay,
Yes this will not increase the reload time of application and it is small inline table so there is no difference i believe in the start and end time. If there is large data set then you find difference in the start and end.
Regards,
Anand
you may wann try it like shown in attached qvw
Hi Ajay,
Let assume this simple load
LET vStartSales = Now();
Sales:
LOAD
Rand() as Sales
AutoGenerate 5200000;
LET vEndSales = now();
LET vStartProduct = Now();
Products:
LOAD
Rand() as Product
AutoGenerate 5200000;
LET vEndProduct = Now();
LET vStartMutual = Now();
Mutual:
LOAD
Rand() as Mutual
AutoGenerate 5200000;
LET vEndMutual = Now();
And after this you get values in the variables by plot them in the text object.
Regards
Anand
Thanks Anand.Its working.
Can i use these variables in other application?
Ajay
Yes that's correct.