# Ruby crawling on a Win2003 Server

**URL:** <https://www.ruby-forum.com/t/ruby-crawling-on-a-win2003-server/79401>\
**Category:** Ruby\
**Created:** [March 10, 2006, 10:39am UTC](https://www.ruby-forum.com/t/ruby-crawling-on-a-win2003-server/79401 "2006-03-10T10:39:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![marcan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/6bbea6/32.png) [@marcan](https://www.ruby-forum.com/u/marcan)\
**Post date:** [March 10, 2006, 10:39am UTC](https://www.ruby-forum.com/t/ruby-crawling-on-a-win2003-server/79401/1 "2006-03-10T10:39:04Z")

</div>

I have an application that makes heavy use of ActiveRecord to fetch data  
and publish to files. When running on my local machine (a laptop with  
WinXP) I produce 1-2 files per second which is perfectly acceptable.  
When running in the production environment (a Windows 2003 server with  
double processors and mucho memory) it crawls. It takes about 30 seconds  
to produce each file (using the same dataset although running on  
different db servers (localhost (which is contextual…) MySQL 4.1.x in  
both cases)).

Is there anyone who has any idea of what might be going on? Any  
profiling tips for a Ruby noob?

Ruby 1.8.2 is used.

Thanks

/Marcus

---

<div class="post-metadata">

**Author:** ![marcan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/6bbea6/32.png) [@marcan](https://www.ruby-forum.com/u/marcan)\
**Post date:** [March 10, 2006, 11:04am UTC](https://www.ruby-forum.com/t/ruby-crawling-on-a-win2003-server/79401/2 "2006-03-10T11:04:51Z")

</div>

Marcus A. wrote:

> I have an application that makes heavy use of ActiveRecord to fetch data  
> and publish to files. When running on my local machine (a laptop with  
> WinXP) I produce 1-2 files per second which is perfectly acceptable.  
> When running in the production environment (a Windows 2003 server with  
> double processors and mucho memory) it crawls. It takes about 30 seconds  
> to produce each file (using the same dataset although running on  
> different db servers (localhost (which is contextual…) MySQL 4.1.x in  
> both cases)).
> 
> Is there anyone who has any idea of what might be going on? Any  
> profiling tips for a Ruby noob?
> 
> Ruby 1.8.2 is used.
> 
> Thanks
> 
> /Marcus

Try looking at the Windows Event Viewer first in Computer Management.

---

<div class="post-metadata">

**Author:** ![marcan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/6bbea6/32.png) [@marcan](https://www.ruby-forum.com/u/marcan)\
**Post date:** [March 10, 2006, 1:13pm UTC](https://www.ruby-forum.com/t/ruby-crawling-on-a-win2003-server/79401/3 "2006-03-10T13:13:38Z")

</div>

Marcus A. wrote:

> profiling tips for a Ruby noob?
> 
> Ruby 1.8.2 is used.

I’d try to profile with PerfMon as well as Ruby’s profiler. For  
databases  
often IO is the bottleneck, so if your 2003 server is slow then maybe  
it’s  
doing something else. Online virus scanners often also have an  
adversary  
effect on performance… HTH

Kind regards

```
robert
```

---

<div class="post-metadata">

**Author:** ![marcan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/6bbea6/32.png) [@marcan](https://www.ruby-forum.com/u/marcan)\
**Post date:** [March 10, 2006, 1:16pm UTC](https://www.ruby-forum.com/t/ruby-crawling-on-a-win2003-server/79401/4 "2006-03-10T13:16:40Z")

</div>

Robert K. skrev:

> I’d try to profile with PerfMon as well as Ruby’s profiler. For databases  
> often IO is the bottleneck, so if your 2003 server is slow then maybe it’s  
> doing something else. Online virus scanners often also have an adversary  
> effect on performance… HTH

Okay. I’ll look into this. Thanks.

/Marcus