Performance

[#1]

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.

[jagan · Accepted solution]

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.

[#3]

Hi Kabil

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

[#4]

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.

[#5]

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

[jagan]

Yes.

Regards,

Jagan.

[#7]

thanks .