topic performance check in Application Development and Automation Discussions

performance check

Former Member — Thu, 06 Aug 2009 08:01:56 GMT

HI ,

I have method that doing create of user with some logic on the Z table on DB ,

The time that take for creation is 16.837 micro sec and for update 2.989 Microseconds

HOw it for performance aspects ?

Regards

chirs

Re: performance check

HermannGahm — Thu, 06 Aug 2009 08:16:38 GMT

Hi Chris,

I'm not sure what exactly your question is.

~17 milli seconds for creating a record and ~3 milli seconds for updating a record doesn't sound too bad.

on the other hand... if you create 5 million records with 17 ms each... you need almost a whole day (~24 hours) for doing so

So what exactly is the question or problem?

Kind regards,

Hermann

Re: performance check

Former Member — Thu, 06 Aug 2009 08:49:41 GMT

Hi Hermann,

in Chris's example microseconds is used,

so on basis of your example with 5.000.000 records

it would take 85 seconds - that is hell of a fast app! ( on the other hand this is hell of a expensive system, 5.000.000 users!)

@Chris: What is your question? Performance optimization?

Without knowing what your are doing in your app, we cannot

give any hints...

Regards

REA

Edited by: Ramy EL-ARNAOUTY on Aug 6, 2009 10:59 AM

Re: performance check

HermannGahm — Thu, 06 Aug 2009 09:20:35 GMT

Hi REA,

maybe i interpreted the figures wrong i used the following:

16.837 micro sec = 16837 micro sec = ~17 milli sec (since no tool i know measures nano seconds....)

so:

16.837 micro sec multiplied by 5.000.000 records = 84185000000 micro seconds

84185000000 micro seconds = 84185000 milli seconds

84185000 milli seconds = 84185 seconds

84185 seconds = 23,38 hours

23,38 hours = ~ 1 whole day

But you are right 5 Million is probably a bit high...

what i meant... even small units of code with small amounts of time could contribute significant

if you execute the small units often enough... in case of inserting a record, if you have to insert

many of them an array interface should be used instead of doing it one by one...

but, back to the question: what the probem/question exactly is...

Kind regards,

Hermann

Re: performance check

Former Member — Thu, 06 Aug 2009 09:28:39 GMT

Hi Hermann,

EDIT:

your are right...

OK habs verstanden:

hier dreht sich nicht um einen dezimalpunkt sondern um ein tausender trennzeichen. alles klar: asche über mein Haupt, und ich behaupte das Gegenteil

Edited by: Ramy EL-ARNAOUTY on Aug 6, 2009 11:29 AM