Win a copy of Classic Computer Science Problems in Swift this week in the iOS forum!

kundan sinha

Greenhorn
+ Follow
since Aug 01, 2005
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by kundan sinha

Hi Rahul,

How are you getting these Execution Statistics ?

kundan
11 years ago
Hi,

Thanks for suggestions.

Earlier I was removing the whitespaces in jsp through ANT task at build time. As javascript is heavly used and I could not remove whitespaces in javascripts so Filter compression would certaily help in some of the pages where page size is problem.
Reducing the size of the page and display time is important. I would have to check what would be the overhead of filter.

kundan
[ September 21, 2006: Message edited by: kundan sinha ]
11 years ago
Hi,

I want to know whether whitespace through extra lines or by tabbing could be performance issue in jsp.
Sometimes client ask that page limit should be max upto 30KB.To get through this line in complex pages what possible options?

How you check the size of the generated page?

kundan
11 years ago
Hi,

No you can't get that detail in it. It will help you to get the execution time of methods, query and load time of js,css.

You can get the max,min,avg,hits,std.

kundan
11 years ago
Hi steve,

I have used JAMon.It's really nice tool(filter api). I like the report it generates.But my concern is to do stress testing. I want that my application gets N hits and I could check this N variable for performance.

I find one thing missing is JAMon is Datasource connectivity.Although I found way around to put things in code. Over all a very nice too.


Kundan
11 years ago
Hi,

Can you please suggest some good tutorial for using grinder in j2ee app.
How can I simulate multiple request?
I have downloaded it and trying to work out with script


my console output is like this



What is grinder.py?

Please help

with regards
kundan
11 years ago
Hi,

I am also having similar problem. One of my jsp takes 6 seconds to get load in development/SIT environment but in production it is taking 40 seconds. Other jsp's are working fine.

So what could be the problem here?

About it's architecture. This jsp includes 6 jsp in it.



Every jsp on production taking 6 seconds and making this page loading in 40 seconds.

I am using Sun server 8.1 and oracle as DB.

How can i find out where is the problem?

with regards
Kundan
[ September 20, 2006: Message edited by: kundan sinha ]
11 years ago
Hi,

Whether to work on customization project or move to some development work.

My last 2 project were development work.

Now I am working on a workflow product which is developed in java,jsp and lot of javascript.
Mostly the work is to customize the product for different customers.

My present manager says that most of the work is like this in other companies too and he wants that I should learn the deep insideout of the product. How thing works inside? Although I know much in detail about it but the work should be like this that I should know the tablename and fieldname, query,methods of each and every call whether it is a part of my module or not.

So this way I am gaining my experience in java or in the product. I hardly write much code in it. Most of the work in copy paste because the product is already been developed.

If there is some performance issue then also I can't change the design of the page but have to work on how much i can increase the performance with same design. Lot of sub queries are written but we can't get them in to java collection classes or stored procedures.

I think we learn much in development work then in customization where we just copy paste someone else code. One has to document for each line why it has been written. Customize the test cases. Clear the TPR.

My manager says that we can not always involved in development projects so customization and maintenance/support project are key area of the growth(onsite/monetary wise).

I want to know that most of the onsite job(development work in US/UK) are related to support and maintenance(copy/paste) or development work is still there.
And How much it is important to be a functional expert(domain expert) rather then a technical expert.

I have SCJP, SCBCD with good experience in j2ee(mostly open source framework),web services, AJAX.

These days to keep in touch with latest technologies, I have to develop dummy project on my own at home.

This ways I am going toward success or just time passing with present job.
11 years ago
Hi,

I have this query running in application and I found out that this query was taking maximum time in execution. Can any body help me in optimizing this query.

Your suggestions are welcome


SELECT (A.FIRST_NAME||' ' ||A.LAST_NAME) NAME,

b.EXTERNAL_ID EMPLID ,

decode(d.descr,NULL,'', d.descr ) jobcodedescr,

decode(f.descr2,NULL,'', f.descr2 ) deptdescr,

decode(i.descr2,NULL,'', i.descr2 ) city

from

(
select descr2 ,fieldvalue FROM sp_code_descr_tbl y WHERE fieldname='LOCATION' and language_cd='ENG'
and EFFDT = (select max(effdt) from sp_code_descr_tbl where fieldname=y.fieldname and language_cd=y.LANGUAGE_CD
and fieldvalue =y.FIELDVALUE
and effdt <= trunc(sysdate))
) i,

(
select person_id,jobcode,deptid,location,setid_jobcode,setid_dept,setid_location from sp_job z where
person_id=':1:' and empl_rcd_num = (select max(empl_rcd_num) from sp_job where person_id = z.person_id)
and effdt = (select max(effdt) from sp_job where person_id = z.person_id)
and effseq = (select max(effseq) from sp_job where person_id = z.person_id)
) c ,

(
SELECT descr2 ,fieldvalue FROM sp_code_descr_tbl x where fieldname='DEPT' and language_cd=':2:'
and EFFDT =( select max(effdt) from sp_code_descr_tbl where fieldname=x.fieldname and language_cd=x.LANGUAGE_CD
and fieldvalue =x.FIELDVALUE
and effdt <= trunc(sysdate))
) f ,

(
select descr ,fieldvalue FROM sp_code_descr_tbl y WHERE fieldname='JOBCODE' and language_cd=':2:'
and EFFDT = (select max(effdt) from sp_code_descr_tbl where fieldname=y.fieldname and language_cd=y.LANGUAGE_CD
and fieldvalue =y.FIELDVALUE
and effdt <= trunc(sysdate))
) d ,

(
select external_id,person_id FROM sp_pers_trnsltn_t WHERE DATA_SRCE_CD = 'HRMS_GEMS' and person_id =':1:'
) b ,

sp_names a

WHERE
a.person_id =':1:'
and a.name_type = ':3:'
and a.effdt = (select max(effdt) from sp_names where person_id = a.person_id and name_type =a.name_type
and effdt <= trunc(sysdate))
AND c.person_id(+)= a.person_id
AND i.fieldvalue(+) = c.location
AND f.fieldvalue(+) = c.deptid
and d.fieldvalue(+) = c.jobcode
and b.person_id (+) = a.person_id
Hi,

How can i take a jvm dump when server is running. i am using sun one server and sometimes it shows a slow response.

any suggestions

with regards
Kundan
12 years ago
Hi scott,

thanks for your good suggestions on my query. I am not having two options either to break it up in java or do inner joins as you recomended.

Secondly I want to know any profiler tool which i can use to check my query.

with regards
Kundan
Dear Friends,

I have written a query which takes around 2 minutes to execute. Is it possible to cut the time in execution. Any trick


with regards
kundan

[ December 05, 2005: Message edited by: kundan sinha ]
[ December 05, 2005: Message edited by: kundan sinha ]
Hi,

If you have couple of year f experience in java/j2ee then your don't need question from the net. Interviewer will ask you about what you have done in these couple of year. Answer them....

thanks and regards
kundan
12 years ago
Thanks Everybody for giving me the inputs.

I am presently working in noida(India) and after a talk with my company they have increased the package to 40k+7.5(Bonus) per year.
Location is most probably Irvine.

thanks and regards
Kundan
12 years ago
Hi Everybody,

I want to ask you all few queries regarding H1.My company is going to file H1 for me. They are giving me 35k+ (7.5k as bonous) per year. I think this is really very less. How much should i ask to stay there with my wife?(Round about figure in california state). Location is still not clear.

Second thing. Do US law allow H1 dependent as my wife to get a job there? She is also an IT professional but do not have adequate experience to file H1.

thanks and regards
Kundan Sinha
12 years ago