topic Re: Performance in QlikView

Performance

Wed, 18 Dec 2013 07:05:44 GMT

Hi Experts,

We are using same Database for both prod and development same task are running in the both server.

I wan to know is it affect the speed of query?

Because same database accessing by the environment at the same time. if there is performance issue then how to avoid this?

Thanks In advance..

Regards,

Kabilan K.

Re: Performance

jagan — Wed, 18 Dec 2013 07:29:06 GMT

Hi,

There may be performance issues if you are loading huge data and complex queires, because both try to access the same and the load is doubled, why can't schedule development and prod tasks at different times?

Regards,

Jagan.

Re: Performance

Wed, 18 Dec 2013 07:37:42 GMT

Hi Kabil

In Development environment limit your data usage, no need all data exact...like when you are load use where conditions

Re: Performance

Wed, 18 Dec 2013 07:43:24 GMT

Yes, we can schdule the task at diff time.

So, Performance issue is there, when we access the same table in same DB in both environment.

If I am wrong correct me.

Re: Performance

Wed, 18 Dec 2013 07:45:54 GMT

development server need to be act as a alternate server for production server, so that we need to load the all data like production.

Re: Performance

jagan — Wed, 18 Dec 2013 07:46:13 GMT

Yes.

Regards,

Jagan.

Re: Performance

Wed, 18 Dec 2013 07:48:42 GMT

thanks .