Skip to content

Instantly share code, notes, and snippets.

@alexjp
Created September 1, 2015 16:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alexjp/292284778d1032891ca8 to your computer and use it in GitHub Desktop.
Save alexjp/292284778d1032891ca8 to your computer and use it in GitHub Desktop.
Problem with tds_ecto and float performance
/****** Object: Table [dbo].[SQLDBTable] Script Date: 01/09/2015 17:43:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SQLDBTable](
[Ano] [smallint] NOT NULL,
[Description] [nvarchar](20) NOT NULL,
[Note] [nvarchar](3) NOT NULL,
[FField00Plus] [money] NULL CONSTRAINT [SQLDBTable_FField00Plus_DF] DEFAULT ((0)),
[FField01Plus] [money] NULL CONSTRAINT [SQLDBTable_FField01Plus_DF] DEFAULT ((0)),
[FField02Plus] [money] NULL CONSTRAINT [SQLDBTable_FField02Plus_DF] DEFAULT ((0)),
[FField03Plus] [money] NULL CONSTRAINT [SQLDBTable_FField03Plus_DF] DEFAULT ((0)),
[FField04Plus] [money] NULL CONSTRAINT [SQLDBTable_FField04Plus_DF] DEFAULT ((0)),
[FField05Plus] [money] NULL CONSTRAINT [SQLDBTable_FField05Plus_DF] DEFAULT ((0)),
[FField06Plus] [money] NULL CONSTRAINT [SQLDBTable_FField06Plus_DF] DEFAULT ((0)),
[FField07Plus] [money] NULL CONSTRAINT [SQLDBTable_FField07Plus_DF] DEFAULT ((0)),
[FField08Plus] [money] NULL CONSTRAINT [SQLDBTable_FField08Plus_DF] DEFAULT ((0)),
[FField09Plus] [money] NULL CONSTRAINT [SQLDBTable_FField09Plus_DF] DEFAULT ((0)),
[FField10Plus] [money] NULL CONSTRAINT [SQLDBTable_FField10Plus_DF] DEFAULT ((0)),
[FField11Plus] [money] NULL CONSTRAINT [SQLDBTable_FField11Plus_DF] DEFAULT ((0)),
[FField12Plus] [money] NULL CONSTRAINT [SQLDBTable_FField12Plus_DF] DEFAULT ((0)),
[FField13Plus] [money] NULL CONSTRAINT [SQLDBTable_FField13Plus_DF] DEFAULT ((0)),
[FField14Plus] [money] NULL CONSTRAINT [SQLDBTable_FField14Plus_DF] DEFAULT ((0)),
[FField15Plus] [money] NULL CONSTRAINT [SQLDBTable_FField15Plus_DF] DEFAULT ((0)),
[FField00Minus] [money] NULL CONSTRAINT [SQLDBTable_FField00Minus_DF] DEFAULT ((0)),
[FField01Minus] [money] NULL CONSTRAINT [SQLDBTable_FField01Minus_DF] DEFAULT ((0)),
[FField02Minus] [money] NULL CONSTRAINT [SQLDBTable_FField02Minus_DF] DEFAULT ((0)),
[FField03Minus] [money] NULL CONSTRAINT [SQLDBTable_FField03Minus_DF] DEFAULT ((0)),
[FField04Minus] [money] NULL CONSTRAINT [SQLDBTable_FField04Minus_DF] DEFAULT ((0)),
[FField05Minus] [money] NULL CONSTRAINT [SQLDBTable_FField05Minus_DF] DEFAULT ((0)),
[FField06Minus] [money] NULL CONSTRAINT [SQLDBTable_FField06Minus_DF] DEFAULT ((0)),
[FField07Minus] [money] NULL CONSTRAINT [SQLDBTable_FField07Minus_DF] DEFAULT ((0)),
[FField08Minus] [money] NULL CONSTRAINT [SQLDBTable_FField08Minus_DF] DEFAULT ((0)),
[FField09Minus] [money] NULL CONSTRAINT [SQLDBTable_FField09Minus_DF] DEFAULT ((0)),
[FField10Minus] [money] NULL CONSTRAINT [SQLDBTable_FField10Minus_DF] DEFAULT ((0)),
[FField11Minus] [money] NULL CONSTRAINT [SQLDBTable_FField11Minus_DF] DEFAULT ((0)),
[FField12Minus] [money] NULL CONSTRAINT [SQLDBTable_FField12Minus_DF] DEFAULT ((0)),
[FField13Minus] [money] NULL CONSTRAINT [SQLDBTable_FField13Minus_DF] DEFAULT ((0)),
[FField14Minus] [money] NULL CONSTRAINT [SQLDBTable_FField14Minus_DF] DEFAULT ((0)),
[FField15Minus] [money] NULL CONSTRAINT [SQLDBTable_FField15Minus_DF] DEFAULT ((0)),
[FField01OR] [money] NULL CONSTRAINT [SQLDBTable_FField01OR_DF] DEFAULT ((0)),
[FField02OR] [money] NULL CONSTRAINT [SQLDBTable_FField02OR_DF] DEFAULT ((0)),
[FField03OR] [money] NULL CONSTRAINT [SQLDBTable_FField03OR_DF] DEFAULT ((0)),
[FField04OR] [money] NULL CONSTRAINT [SQLDBTable_FField04OR_DF] DEFAULT ((0)),
[FField05OR] [money] NULL CONSTRAINT [SQLDBTable_FField05OR_DF] DEFAULT ((0)),
[FField06OR] [money] NULL CONSTRAINT [SQLDBTable_FField06OR_DF] DEFAULT ((0)),
[FField07OR] [money] NULL CONSTRAINT [SQLDBTable_FField07OR_DF] DEFAULT ((0)),
[FField08OR] [money] NULL CONSTRAINT [SQLDBTable_FField08OR_DF] DEFAULT ((0)),
[FField09OR] [money] NULL CONSTRAINT [SQLDBTable_FField09OR_DF] DEFAULT ((0)),
[FField10OR] [money] NULL CONSTRAINT [SQLDBTable_FField10OR_DF] DEFAULT ((0)),
[FField11OR] [money] NULL CONSTRAINT [SQLDBTable_FField11OR_DF] DEFAULT ((0)),
[FField12OR] [money] NULL CONSTRAINT [SQLDBTable_FField12OR_DF] DEFAULT ((0)),
[Type] [varchar](3) NOT NULL CONSTRAINT [SQLDBTable_Type] DEFAULT ('000'),
[Nature] [varchar](1) NOT NULL CONSTRAINT [SQLDBTable_Nature] DEFAULT ('C'),
CONSTRAINT [SQLDBTable01] PRIMARY KEY CLUSTERED
(
[Type] ASC,
[Ano] ASC,
[Note] ASC,
[Description] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
defmodule Example.Sync.SQLDBTable do
use Example.Web, :model
alias Example.Repo
alias Example.SQLDBRepo
@primary_key {:id, :string, autogenerate: false}
schema "example_table" do
field :name, :string
field :year, :integer
field :description, :string
field :note, :string
field :ffield00plus, :float
field :ffield00minus, :float
field :ffield01plus, :float
field :ffield01minus, :float
field :total01, :float
field :ffield02plus, :float
field :ffield02minus, :float
field :total02, :float
field :ffield03plus, :float
field :ffield03minus, :float
field :total03, :float
field :ffield04plus, :float
field :ffield04minus, :float
field :total04, :float
field :ffield05plus, :float
field :ffield05minus, :float
field :total05, :float
field :ffield06plus, :float
field :ffield06minus, :float
field :total06, :float
field :ffield07plus, :float
field :ffield07minus, :float
field :total07, :float
field :ffield08plus, :float
field :ffield08minus, :float
field :total08, :float
field :ffield09plus, :float
field :ffield09minus, :float
field :total09, :float
field :ffield10plus, :float
field :ffield10minus, :float
field :total10, :float
field :ffield11plus, :float
field :ffield11minus, :float
field :total11, :float
field :ffield12plus, :float
field :ffield12minus, :float
field :total12, :float
field :type, :string
end
@required_fields ~w()
@optional_fields ~w()
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment