You cannot post messages because only members can post, and you are not currently a member.
Description:
place for discussing improvements and bug fixes for the Rails ActiveRecord SQLServer Adapter.
|
|
|
Speed
|
| |
I've been working on optimizing a data intensive display of ours, and I noticed that a query which returns ~1500 rows takes a significant amount of time to process all the rows returned. The data from the query itself returns in <150ms (yes, it could be faster, and will be), but it's taking 2.31s for the ActiveRecord call to return.... more »
|
|
|
Milliseconds are stripped?
|
| |
I've read another thread in this group regarding the millisecond support using _before_type_cast on the column name but I don't seem to be getting the same result: ActiveRecord connection used: => #<ActiveRecord::ConnectionAdap ters::SQLServerAdapter version: 2.2.21, year: 2008, connection_options: ["DBI:ADO:Provider=SQLOLEDB;Da ta Source=.......... more »
|
|
|
Hiring An App Developer
|
| |
My work place is hiring a developer. SQL Server is not a requirement since that is abstracted away with the adapter. We are looking for someone with good web application skills, some JavaScript, and general good work ethic. The company is in Virginia but remote telecommute is an option (as that is what I do). If anyone is interested, send me an email.... more »
|
|
|
Ceàgo vs Ce?go
|
| |
Howdy, thanks for open-sourcing this adapter! Its made life bearable when dealing with SQL Server and Rails. I've been seeing strange behavior with data that includes accents. (Not sure if this qualifies as unicode or not, since I recall accented letters being in the ASCII charset.) In irb, all is well:... more »
|
|
|
Must use table name in complex conditions
|
| |
I posted this a while back on the rails forum but it not get much attention, and thought some other folks may experience the same issue. -------ORIGINAL POST-------- I'm working with a legacy MSSQL database with non-traditional table names and foreign keys. For our purposes tablel 1 is named 'tblFoo"... more »
|
|
|
Problem using SQL Server adapter with ActiveScaffold (with patch)
|
| |
Hi. I was getting strange "double-bracketed" field names when I swapped out SQL Server for MySQL on my Rails app. I use the ActiveScaffold (AS) plugin and for whatever reason when AS used the standard ActiveRecord #find methods, I was getting SQL exceptions indicating that the underlying SQL was getting double-brackets on... more »
|
|
|
"Unable to load driver 'ODBC'" on windows w/ruby 1.9
|
| |
Hey All, I'm trying to use the sql server adapter on a windows XP machine from a plain ruby script and am getting the subject error. Here's my script: ...require 'dbi' require 'activerecord' require 'activerecord-sqlserver-adapte r' db_config = { :adapter => 'sqlserver', :mode => 'ODBC', :server => 'ctrhs-sql2k\sql2k',... more »
|
|
|
Add option for specifying total row count to add_limit_offset!
|
| |
It'd be great if we could bypass the automatic row counting performed
in #add_limit_offset! by specifying a count ourselves somehow.
If you're using will_paginate, the total row counts are being
performed twice - once by will_paginate and then once again by the
adapter in #add_limit_offset!.... more »
|
|
|
optimistic offline locking using a timestamp column
|
| |
Hi
I have the following problem: We have a large legacy database on MS
SQL Server 2005. Each table uses a timestamp column to implement
optimistic offline locking. We want to build a rails application that
uses this database as is. Is there a way that rails can use the
timestamp columns for its own locking magic?... more »
|
|
|
|
