This question is locked. New answers and comments are not allowed.
We are using Data Access with WebAPI to supply data to our website. We have been using JMeter to test a simple web method to return data. Even through our LINQ and resultant SQL from the LINQ does not change the more columns that we map the slower the throughput gets. Mapping 5 columns we can achieve 200 requests per second, but with 100+ columns mapped we are suddenly down to 10 requests per second. Again the SQL statements do not change in this case only the number of columns being mapped that are never even used. A sample of our mapping code is below. We have also tested progressively adding columns and it gets worse the more that you add (progressively getting slower). Can someone help explain this behavior? Thank you.
var configuration =
new
MappingConfiguration<Sku>();
configuration.MapType().ToTable(
"SKU"
);
configuration.HasProperty(x => x.ImageRecnbr).IsIdentity().HasFieldName(
"_imagerecnbr"
).WithDataAccessKind(DataAccessKind.ReadWrite).ToColumn(
"IMAGE_RECNBR"
).IsNotNullable().HasColumnType(
"decimal"
).HasPrecision(10).HasScale(0);
configuration.HasProperty(x => x.SkuInternal).HasFieldName(
"_skuinternal"
).WithDataAccessKind(DataAccessKind.ReadWrite).ToColumn(
"SKU_INTERNAL"
).IsNotNullable().HasColumnType(
"decimal"
).HasPrecision(9).HasScale(0);