.net - Database Datatype Performance: Int Or String
Jan 18, 2011
I'm storing phone country codes. They range from 1 to about 300. What's going to be more performant for datatype: int or string? I'm using SQL server 2008 and linq-to-sql.
View 7 Replies
Similar Messages:
Jan 21, 2010
i am store ms word resume to image(BLOB) data type in sql server 2005. now i want to display this resume in HTML page or in text area. and for that i use
[code]....
View 3 Replies
Aug 3, 2010
How it is possible to assign datatype of an attribute retrieved using sql query to a string? for eg:
SqlCommand cmd = new SqlCommand("select data_type from information_schema.columns where table_schema='dbo' AND table_name=table1 AND column_name=column1, con);
I want to assign this datatype value to a string. How it is possible?
View 4 Replies
Nov 24, 2010
I'm loading data from my database into a DataTable, and one of the columns is a date field.
[Code]....
I'd like to format that column so that instead of containing a full date, it will be formatted like "MM/DD/YYYY".
I've tried looping through each row in the table and changing the cell for that column, but I get an error saying that the string isn't a valid DateTime object.
I tried changing the column DateType to a string, but I get an error saying I can't change the DateType after the table is filled.
How can I do this? This seems like such a simple thing, but I'm having so much trouble with it.
View 3 Replies
Jun 25, 2010
convert below datetime value which is as varchar datatype to another datetimeformat as varcharchar datatype
2010-05-19T13:05:08.6Z
View 3 Replies
Sep 28, 2010
can u tell me what datatype i should use for TimeIn and TimeOut of the employee in database.
In frontend i am storing TimeIn and TimeOut as object.
View 1 Replies
Jan 22, 2010
I have been looking for a way to convert C# datatype into database specific type of MS SQL. For example when I do [Code]....
I would get System.GUID or something like that but what I want is UniqueIdentifier instead of System.GUID. In most cases, I would also want the length of the type like varchar(1000) and stuff like that. Is there anyway I could convert or get similiar result ?
View 6 Replies
Mar 7, 2011
There is one table which primary key is ID and its data type is Integer with auto increment. Gradually the value has increased and I want to change it to hold large amount of value.
So, Which in data type I have to change from Integer without effecting the previous values?
View 2 Replies
Jan 21, 2011
I should store application configuration data and default text values that will have the best performance overall. For example, I've been sticking stuff like default URL values and the default text for error messages or application instructions inside the web.config, but now I'm wondering if that will scale...
View 4 Replies
Sep 29, 2010
I am creating a site whose content is dynamic and has images in it.How much performance hit will my DB (MSSQL) take if I save content/Images in DB?
View 3 Replies
Sep 20, 2010
I have developed a website in asp.net framework 2 . This website is being hosted in two different servers without any change in code. My issue is about the performance of these 2 sites. One website is taking much time for inserting datas to the DB (SQL server 2005). 2 websites are having different DB server.
I think the issue is for the DB server. How can we rectify the DB performance while insertion and Is there any other cause for this permance issue?
View 1 Replies
Feb 11, 2010
I was recently asked to speed up a C#/ASP.NET/SQL Server business app website. Since I just started, I don't know too much about the internals. So where do I start? Sight unseen, what is the single most important thing affecting performance on a system like this? Database tuning? Hardware? Individual page optimization? What is the first thing you'd look at? EDIT: After I actually do the work, I'll come back and post the answer. ;)
EDIT again: "Profile" is currently the most-voted answer, and I agree that that is clearly what one should do. But I was looking for guesses/experience as to what the profiling results would show, so I don't think that answer counts...
View 8 Replies
Apr 29, 2010
I am not sure if this is the right forum. I can not find a forum for LINQ.
I am working on an application using LINQ. Application performance is not up to par and my tests show that it is LINQ queries that are slow. I was wondering if anybody can recommend where I can find an article about optimizing LINQ performance maybe by compilation or other methods.
View 1 Replies
Mar 20, 2011
I am creating a service oriented application where trying to have everything using services....however there is something I am not sure of , I am having a page that calls the database at the page load...so what would be better and faster?? to call database in pageload , or to call wcf service from javascript during javascript load ??btw , I am using a repeater in the page , but I have created somekind of an engine to create the suitable html so...I'll be creating the repeaters html using the wcf and resend it back to the page If I am using a wcf service at the start.
View 1 Replies
Dec 2, 2010
Is StringBuilder a datatype?
View 9 Replies
Jul 23, 2010
i am jqgrid which is binded dynamically using json datatype.my problem is with pageing.
I wrote the script for jqgrid in AddCategory.aspx and redirected this page to AddCategoryGrid.aspx where i wrote the code for binding jqGrid data.
It is displaying all records in one page but not allowing the pagging.
[code]....
View 1 Replies
Aug 17, 2010
I ve seen more Sites but i can't able to understand guys
Ex:("CultureInfo culture = new CultureInfo( "hi-IN" );")
View 3 Replies
Dec 12, 2010
I bind a member's ID (primary key of type Int32) to the selectedvalue of a ddl, and the user name to the text. This has worked fine until now. I have just exceeded 255 members and it is crashing when I bind any member with an ID value 256 or greater.My error is, "'ddl3HomePlayer' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value"I think the problem is that a ddl.selectedvalue can't exceed 255. Is this correct? How do I set the selected value to type Int32?
View 4 Replies
Nov 10, 2010
I'm not sure if this problem is isolated in MVC2 or if it's isolated with the DataType.EmailAddress, but that's what I'm working on.
Anyway, I noticed that no validation is performed at all on my field marked with [DataType(DataType.EmailAddress)], both on client and server.
Here is the Model:
[Code]....
Here is the View:
[Code]....
Here are the Controller Actions:
[Code]....
Validation for the [Required] attributes are working fine. It's the DataType.EmailAddress that never gets checked at all. My ModelState.IsValid returns true even if I enter "x" as my email address. Haven't tried the other DataTypes, so I dunno if this is just for the email or for all types.
View 11 Replies
Nov 8, 2010
I have a web application which talk to Oracle for Database Operations.I want to what will be the equivalent datatype for float in c#.ie for Oracle Varchar2 , in c# we can give string like that for Float in oracle what will we give in C#
View 1 Replies
Nov 3, 2010
I'm working on an application that has a large number of inputs for certain types (50 money inputs, 30 date inputs etc). I have been creating an CompareValidator for each one to make sure users are putting in the correct information but I am curious if there is an easier way to create the validation once and apply it to all desired inputs? Writing out 80 validators that do basically the same thing seems like a waste. Am I missing something that already does this in .NET or are there anything out there that can make validation easier?
Note: All validation needs to be done on both the client AND server side. I've read a little about ASP.NET MVC validation but unfortunately that won't be an option here.
View 1 Replies
Dec 9, 2010
Can anyone tell me what datatype i should use for STartTime and EndTime.
StartTime value will consist values like Off,Vacation etc apart time.
View 1 Replies
Jan 11, 2010
This is actually a situation where LINQ as follow:
Code:
Dim query = From loadedfile In dtloadedfile.AsEnumerable() _
Join householdPanels In dtHouseholdPanels.AsEnumerable() _
On CType(loadedfile("Household_number"), Integer) Equals _
[code]...
when i get to col.DataType = t.PropertyType, i hit an error where it says Nullable datatype is not allowed. I know the t.propertytype returns nullable as datatype, however, this nullable type do have a normal datatype declared too. ie Of System.Nullable(Of Integer) from the LINQ query. But how do i get that information?
ps: this function is taken somewhere from the web, so you might recognise it.
View 5 Replies
Aug 9, 2010
In MSSQL server 2005/2008, we have one column (in a table) declares as "Image" type. What data type in C# so I can grab that value in that column in our class? Can string handle it or byte[]?
View 1 Replies
Nov 16, 2010
I have a tabe related to songs which has columns like songID, album, Artist, track etc. I want the data for track to be entered in the format 1/2, 2/2 like this. What shpuld b the datatype of this value? If I'm entering a new data or updating the columns from a web page how can I check the track textbox to enter the correct value? Can I use any validation control? if so how can i use it?
View 6 Replies