NAS and processing speed

DRB · 2010-12-27

Hello All,

I was just wondering if running a particular job by NAS has any impact on its processing time. I have a scenario wherein a task when run by NAS takes 8 hours, but running it without using NAS takes 45-50 minutes.

In this case NAS is running on the server, and even the while running without NAS is also done on the server machine, so I guess there is no change because of hardware infrastructure etc.

Is there something that can be done to make it faster?

Please suggest.

Belias · 2010-12-27

reeeeaaaally stupid question, but who knows: is there a "suspect" part of process conditioned by GUIALLOWED?

DRB · 2010-12-27

Belias wrote:

reeeeaaaally stupid question,

Thanks for your reply....

Belias · 2010-12-27

I've probably been misunderstood...i meant that the "really stupid question" is my one:

is there a "suspect" part of process conditioned by GUIALLOWED

DRB · 2010-12-27

Belias wrote:

I've probably been misunderstood...i meant that the "really stupid question" is my one:

is there a "suspect" part of process conditioned by GUIALLOWED

No, the code is same for GUIALLOWED and without that also. My first inference was also same, but is there any provision of specifying Cache memory etc. in NAS Starting (using a BAT file etc...)?

Belias · 2010-12-27

DRB wrote:

No, the code is same for GUIALLOWED and without that also. My first inference was also same, but is there any provision of specifying Cache memory etc. in NAS Starting (using a BAT file etc...)?

i don't know...
another possibility is that there are multiple NASes and they are running similar jobs at the same time and they're blocking each other :-k

kriki · 2010-12-27

Some things to check:
Check if the NAS is using TCP and not named pipes or default. (If the NAS is on the server, try to use localhost (127.0.0.1) to connect to the DB. This should be the fastest.).
Check if there was nothing else running at the same time that used CPU or other resources.