Created
September 1, 2015 16:49
-
-
Save alexjp/292284778d1032891ca8 to your computer and use it in GitHub Desktop.
Problem with tds_ecto and float performance
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/****** 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 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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