# Large select list, speed issues **URL:** \ **Category:** Rails\ **Created:** [January 9, 2006, 7:05pm UTC](https://www.ruby-forum.com/t/large-select-list-speed-issues/102772 "2006-01-09T19:05:13Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![dmarkow](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/bc8723/32.png) [@dmarkow](https://www.ruby-forum.com/u/dmarkow)\ **Post date:** [January 9, 2006, 7:05pm UTC](https://www.ruby-forum.com/t/large-select-list-speed-issues/102772/1 "2006-01-09T19:05:13Z")
* * * Rails mailing list removed\_email\_address@domain.invalid [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails) ---
**Author:** ![dmarkow](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/bc8723/32.png) [@dmarkow](https://www.ruby-forum.com/u/dmarkow)\ **Post date:** [January 9, 2006, 7:17pm UTC](https://www.ruby-forum.com/t/large-select-list-speed-issues/102772/2 "2006-01-09T19:17:18Z")
Did you take a look at the logs to see what SQL was being generated, and what percentage of the time it took to create the db request, render the page etc? Try to narrow it down a bit. On 1/9/06, Dylan M. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > right now. There are about 1000 projects. In PHP, the page loaded in about – - Nic ---
**Author:** ![dmarkow](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/bc8723/32.png) [@dmarkow](https://www.ruby-forum.com/u/dmarkow)\ **Post date:** [January 9, 2006, 7:20pm UTC](https://www.ruby-forum.com/t/large-select-list-speed-issues/102772/3 "2006-01-09T19:20:19Z")
* * * Rails mailing list removed\_email\_address@domain.invalid [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails) ---
**Author:** ![dmarkow](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/bc8723/32.png) [@dmarkow](https://www.ruby-forum.com/u/dmarkow)\ **Post date:** [January 9, 2006, 7:53pm UTC](https://www.ruby-forum.com/t/large-select-list-speed-issues/102772/4 "2006-01-09T19:53:34Z")
* * * Rails mailing list removed\_email\_address@domain.invalid [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails) ---
**Author:** ![dmarkow](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/bc8723/32.png) [@dmarkow](https://www.ruby-forum.com/u/dmarkow)\ **Post date:** [January 9, 2006, 8:35pm UTC](https://www.ruby-forum.com/t/large-select-list-speed-issues/102772/5 "2006-01-09T20:35:46Z")
I haven’t used it yet, but maybe app/script/performance/profiler will help you learn what’s consuming all that time. SteveT ---
**Author:** ![dmarkow](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/bc8723/32.png) [@dmarkow](https://www.ruby-forum.com/u/dmarkow)\ **Post date:** [January 11, 2006, 3:38pm UTC](https://www.ruby-forum.com/t/large-select-list-speed-issues/102772/6 "2006-01-11T15:38:59Z")
Dylan M. wrote: > now. There are about 1000 projects. In PHP, the page loaded in about half a > second, the rails page takes about 4-5 seconds. I tried manually looping and > generating option tags instead of using the select\_tag method, but it wasn’t > much better. Any suggestions? I would suggest you should try adding :select =\> ‘id, project\_name’ to your find. This way only the id and project\_name will be retrieved in your query, potentially making the instantation of your project records a lot faster. – stefan – For rails performance tuning, see: [http://railsexpress.de/blog](http://railsexpress.de/blog) Subscription: [railsexpress.de](http://railsexpress.de/blog/xml/rss20/feed.xml) ---
**Author:** ![dmarkow](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/bc8723/32.png) [@dmarkow](https://www.ruby-forum.com/u/dmarkow)\ **Post date:** [January 12, 2006, 4:57pm UTC](https://www.ruby-forum.com/t/large-select-list-speed-issues/102772/7 "2006-01-12T16:57:16Z")
* * * Rails mailing list removed\_email\_address@domain.invalid [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails) ---
**Author:** ![dmarkow](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/bc8723/32.png) [@dmarkow](https://www.ruby-forum.com/u/dmarkow)\ **Post date:** [January 13, 2006, 1:35pm UTC](https://www.ruby-forum.com/t/large-select-list-speed-issues/102772/8 "2006-01-13T13:35:24Z")
2006/1/12, Dylan M. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid): > That fixed the problem perfectly. Weird that i had a full “SELECT \*” in PHP > and it still went fast. Thanks!! Take a look at your logs, your SELECT might not have been what you expected it to be (perhaps someJoins you didn’t want?) Douglas