Forum: Ruby on Rails [FATAL] failed to allocate memory

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Jesse C. (Guest)
on 2006-05-22 13:46
(Received via mailing list)
hi,

i used odbc connect ms sqlserver on windows, it raise : [FATAL] failed
to
allocate memory when "select top 10 * from tables", the same app can run
correct on Debian,  how can i fix the error?



--
Best Regards,

Caiwangqin
http://www.uuzone.com
Mobile:  +8613951787088
Tel:  +86025-84818086 ext 233
Fax: +86025-84814993
David M. (Guest)
on 2006-05-23 00:42
(Received via mailing list)
A few ideas:
- your table name "tables" might be an issue; can you try changing it
to something else?
- a "select top 10 ..." query will consume a lot of memory; do you
have enough memory (RAM and virtual) in your SQL Server box to run
this request?
- "select top 10 * ..." doesn't make it clear which criteria you're
using to find the "top" records; I'm not sure how SQL Server would
handle this.  Is it possible to reword this query?

Regards

Dave M.
This topic is locked and can not be replied to.