Optimizing A Table With A Huge Text-field?
Mar 4, 2011
I have a project which generates snapshots of a database, converts it to XML and then stores the XML inside a separate database. Unfortunately, these snapshots are becoming huge files, and are now about 10 megabytes each. Fortunately, I only have to store them for about a month before they can be discarded again but still, a month of snapshots turn out to become real bad for it's performance...I think there is a way to improve performance a lot. No, not by storing the XML in a separate folder somewhere, because I don't have write access to any location on that server. The XML must stay within the database. But somehow, the field [Content] might be optimized somehow so things will speed up...I won't need any full-text search options on this field. I will never do any searching based on this field. So perhaps by disabling this field for search instructions or whatever?The table has no references to other tables, but the structure is fixed. I cannot rename things, or change the field types. So I wonder if optimizations is still possible.Well, is it?The structure, as generated by SQL Server:
CREATE TABLE [dbo].[Snapshots](
[Identity] [int] IDENTITY(1,1) NOT NULL,
[Header] [varchar](64) NOT NULL,[code]....
Performance isn't just slow when selecting data from this table but also when selecting or inserting data in one of the other tables in this database! When I delete all records from this table, the whole system is fast. When I start adding snapshots, performance starts to decrease. After about 30 snapshots, performance becomes bad and the risk of connection timeouts increase.Maybe the problem isn't in the database itself, although it's still slow when used through the management tool. (Fast when Snapshots is empty.) I mainly use ASP.NET 3.5 and the Entity Framework to connect to this database and then read the multiple tables. Maybe some performance can be gained here, although that wouldn't explain why the database is also slow from the management tools and when used through other applications with a direct connection...
View 3 Replies
Similar Messages:
Oct 19, 2010
I have a table with just a column and a row in a table that it save just a file with size 1.5 GB ! C# application and sql server are in different machines. I want to read that file by DataReader every 100 MB then save all 100 MB files to disk by "FileMode.Append" for file stream and collect them to one file.
View 1 Replies
Jan 14, 2010
If we have a huge amount of text with some images then, the text and images should be directly included into an ASP.NET 2.0 page with other server controls or whether they should be included from some outside document like a Word Document ? Which one is the best method of doing this ? Can this be done using an Xml file ? If yes, then how ? What are the advantages and disadvantages of both method (if any) ?
View 2 Replies
Jan 28, 2011
I have a DataTable available with me which contains thousands of rows. There is a column called EmpID which is containing '0' for some of the rows. I want to remove them from my current DataTable and want to create a new correct DataTable. I cannot go row by row checking it since it contains huge amount of data.
View 6 Replies
Apr 2, 2010
I have a requirement to have a multiline textbox that accepts any text from any language and stores this into the database for later use. I am using Linq with ASP .NET 3.5 with a SQL Server 2005 database.
View 2 Replies
Jan 25, 2011
I have one Store Procedure that generating report ..
For storing the data there , i used many temp. tables. There is many Select Query , little less insert and delete query.
Now if there is huge data around 1 lac in temp table my select query taking to much time and also may be insert and delete query
I added Primary key to all auto Increment Field in temp table. Also defined Clustered index on that primary key as unique Clustered index to improve the performance .
But there is not so much improvement in case of huge temp table.
Right now the whole Store Procedure is taking time to complete around 1.5 days or around 30 hours ..
So i want to increase the performance as much that it completes on nearly 3-4 hours.
View 39 Replies
Jan 21, 2010
I have a table named RECIPE which is linked to an other table name RECIPE_STATUS
In RECIPE table I have a field named Status_Id which contains the name of the Status which is fetch from the RECIPE_STATUS table based on this ID.
The RECIPE table sample information are as follow :
ID Name Status_Id
====================
1 Test1 0
2 Test2 1
3 Test3 2
The RECIPE_STATUS entries are as follow:
ID Name
========
0 Locked
1 Running
2 Free
From an ASP.net page I would like that my user is capable of changing the RECIPE_STATUS from a given recipe. For that I have a DataGrid which is bind to the RECIPE table.
But then what I would like is that the STATUS shown to my user to be the name Locked,Running or free depedning on the Id
How can I bound in my Datagrid the Recipe.Status to be bind to RECIPE_STATUS.Id ?
IN addition to that, If my user change the status for a given recipe, it should be properly save.
View 1 Replies
Oct 17, 2010
I have a site running on.NET 4 and it seems sluggish compared to its .NET 3 counterpart even though it is running on a faster box. Is there some type of guide for recommended optimizations on the server to increase performance?
View 2 Replies
Feb 1, 2010
I'm building a asp.net web application with lots and lots of controls and huge volumes of data. My application is very slow and it is taking a large amount of time to load the data into the .net controls like grid, tree view etc. I also have some ajaxified pages and controls in my application. I want to reduce the page load time in each postbacks.What are the standards/best practices to be followed while developing large asp.net applications?
View 3 Replies
Nov 19, 2010
I need to write a query to populate a gridview with minimum rates in ascending order for a month from three tables.For example i have three tables A,B,C as follows
TABLE A TABLE B
TABLE C
Id id id
Quote_no Quote_no Quote_ no
Name Rate1 Equip_name
Rate2 E_rate
Date R1_rate
R2_rate
Date
Now if the data is as follows
I need to get the Name from Table A ,minimum Rate1 and Rate2 values for a month in a dropdownlist from date field from Table B and the corresponding minimum rate(E_rate) for Equipment E1 and E2 only from Table C for the month in ascending order group by Name.
TABLE A
id
Quote_no
Name
1
101
XYZ
2
102
ABC
TABLE B
id
Quote_no
Rate1
Rate2
Date
1
101
105
200
12/11/2010
2
102
90
210
15/11/2010
TABLE C
id
Quote_no
Equip_name
E_rate
R1_rate
R2_Rate
Date
1
101
E1
60
0
0
12/11/2010
1
101
R1
0
110
0
12/11/2010
1
101
E2
80
0
0
12/11/2010
2
102
R2
0
0
300
15/11/2010
2
102
E2
100
0
0
15/11/2010
2
102
R1
0
60
0
15/11/2010
2
102
E1
230
0
0
15/11/2010
View 9 Replies
Feb 28, 2011
I have in my database the News Table which consist of => Id, Title, txt . I need to be able to get a description text from the whole text which exist in txt Field , but without any codes like <...> , just a pure text !! how can I do this?
View 3 Replies
Jan 2, 2010
how to show plain text in password field and then make it regular password field on focus
View 3 Replies
Apr 11, 2014
I have an old database that still contains depreciated Text fields. I need to pull from these fields and display the results. You would think this should be easy... First my select statement caused a problem:
Code:
SELECT DISTINCT ..., CustomerInstructions, ... FROM Orders
where CustomerInstructions is a Text field.
The error I get: "The text data type cannot be selected as DISTINCT because it is not comparable." A quick search shows I can cast the text field as a varchar(max).
Code:
SELECT DISTINCT ..., CAST(CustomerInstructions AS VARCHAR(MAX)), ... FROM Orders
Now I get an error while trying to load the instructions into a text box: "Specified argument was out of the range of valid values. Parameter name: index"
Not sure what the problem is here. I have text and a text box. What's with the "out of range" crap?
View 2 Replies
Nov 3, 2010
I have a SQL Server table with a number of fields that are defined with the "Float" data type. I'm running a simple query to retrieve the data from this table and use it to populate a Data Table in my C#.net application.
I just discovered that the data type of the Data Table fields is Double, not Float as I expected. As such, when I store a value like 0.157 it ends up getting stored like this: 0.15700000524520874
I'm aware that such extra "noise" occurs when such a conversion occurs. My major question has to do with why .Net didn't set the Data Type to Float (ie. Single) when the table was first populated?
View 3 Replies
Dec 23, 2015
I have text more than 1000 character in table. But I want show text from table in crystal report. When I show text in textbox crystal report text out from textbox and can’t seen all text.
For example:
Text out from t
extbox.
For me need like this:
Text out from textbox . it’s need me
How I can solve this?
View 1 Replies
Aug 9, 2010
I am trying to get the row value/inner text from a table I have inside a repeater list. I am using jquery/tableDnD to drag and drop the row at which time I update the row number with the new position. Ultimately I would like to insert these new values into a table but I am having a problem accessing the client changed data using a c# procedure.
[Code]....
View 2 Replies
Jul 2, 2010
I have a multiline text box on page which has style "overflow: hidden" to hide the scroll bar. I want to set the vertical hight of that text box at runtime according to the string coming from table column. Is there any way of doing it? I have tried to put the text in array but its not working....
Dim myParas As Object
myParas = Split(TextBox2.Text, vbNewLine)
ln = UBound(myParas) + 1
TextBox2.Height = 22 * ln
View 4 Replies
Sep 6, 2010
clarify: i am using a virtual keyboard that has to work on deferent text fields, and deferent pages, every time i click on a text field it sould pop up and every key i press i need to show on the text field....the problem, as every one knows, is to bind a deferent text field to the virtual keyboard, And as i said, also, to use it on deferent pages without rewriting the keyboard code for every page again and again, some thing that will not do... still can not give any code as there is no code to give, so there is no code...
i don't have code to show becouse i am trying to figure out how to do this and not showing a problem...
Background: I have an aspx file that holds a keyboard div and a hidden TextArea or an Input type=hidden (not decided yet). This page is a user control so it cen be used in all the pages that needs it...
What i am tring to do: Using JQuery bind('focus',...) method to bind any field in a certian aspx page (not the keyboard UC itself) to the hidden text field, i want that every thing i click on the keyboard will show in the text field that is on focus....
Can i relate in JS/JQuery to a field that is in a different page, will it recognise it? how can i do the bind, how can i transfer text from one field to another? if there a better way to do this, i will be happy to hear about it...
View 1 Replies
Nov 11, 2010
I ma sure this is easy but asp.net is new for me. Anyway I'm trying to collect a username and put it into a SQL database. I collected the username just fine:
Code:
[code]....
Then I tried numerous ways of trying to put it into a text box with no luck:
Code:
<asp:TextBox ID="userNameTextBox" runat="server"
Text=<%Response.Write(Request.ServerVariables("LOGON_USER"))%> />
Can someone tell me what goes in the text box? And if I have the variable set right?
View 10 Replies
Mar 1, 2010
I know that this is easy for those that know but alas this is not me ;)
I have a multi part form that is going to write to a dB.
As a point of reference I can offer [URL](i.e., the quote process) as a model for my project.
I need to write a record on the first page and then use the auto number generated from this to populate the child records with the parent's key field.
What I was hoping to do is write the record and then send the data from the dB to the second form. Iwill then need to repeat this process for the children of the child
I am only moderately familiar with ASP.net
one thing to add is that i am not forcing the user to create an account in order to maje the initial inquiry, only if they wish to reaccess theinformation at a later date.
View 7 Replies
Mar 3, 2011
When adding list item the Value field is being set to the Text field. Initially I though the problem was related to the input parameter for the primary key ( group_type_id ) as it is configured as OUTPUT variable.
Interesting enough, when I Watch all of the values, everything is correct.
So for example, I'll watch these:
ddr["group_type_name"] comes out as "Dept"
ddr["grouptypeid"] comes out as 4
When the item is created however,
itms.TEXT = "Dept"
itms.Value = "Dept" <-- THIS IS THE PROBLEM
I'm at a loss why the listbox values are being set to the text values when I can clearly see the data reader values are correct. ?
Code sample here:
[Code]....
View 1 Replies
Feb 22, 2011
net.3.5 linq 2 sql
if i need to update a single field in the db table - do i need to select all the row first?
can i say update myTable Field2 = x where field1=y?
dont know its look like too mach recourses
Order order =new ();
order.ID = 1; orderStatus = "test";
db.order.attach(order);
db.Refresh(RefreshMode.KeepCurrentValues, oOrder);
db.SubmitChanges();
well that delete all the other fields values
View 4 Replies
Aug 8, 2010
if field in a sql data table is encrypted or not ??!!
like a function that return true or false>>> IsEncrypted()
View 1 Replies
Nov 7, 2010
I want to parse an address from a text field. for example
textbox data = 123 test street, mountain view, CA 91302
Dim address = Address.text
parse(address)
to
Address1
Address2
City
State
Zip
I found someones sample code, but it doesn't work all that well. here it is non the less
Public Function parseAddress(ByVal input As String) As Collection
input = input.Replace(",", "")
input = input.Replace(" ", " ")
Dim splitString() As String = Split(input)
Dim streetMarker() As String = New String() {"street", "st", "st.", "avenue", "ave", "ave.", "blvd", "blvd.", "highway", "hwy", "hwy.", "box", "road", "rd", "rd.", "lane", "ln", "ln.", "circle", "circ", "circ.", "court", "ct", "ct."}
Dim address1 As String
Dim address2 As String = ""
Dim city As String
Dim state As String
Dim zip As String
Dim streetMarkerIndex As Integer
zip = splitString(splitString.Length - 1).ToString()
state = splitString(splitString.Length - 2).ToString()
streetMarkerIndex = getLastIndexOf(splitString, streetMarker) + 1
Dim sb As New StringBuilder
For counter As Integer = streetMarkerIndex To splitString.Length - 3
sb.Append(splitString(counter) + " ")
Next counter
city = RTrim(sb.ToString())
Dim addressIndex As Integer = 0
For counter As Integer = 0 To streetMarkerIndex
If IsNumeric(splitString(counter)) _
Or splitString(counter).ToString.ToLower = "po" _
Or splitString(counter).ToString().ToLower().Replace(".", "") = "po" Then....
[Code...]
View 1 Replies
May 11, 2010
I have an asp gridview that I am exporting to Excel. The data exports perfectly except for fields that are text fields with leading zeros. I have a field in the data grid for job number that has leading zeros. When that data is exported to Excel 000564 gets exported as only 564.Is there DataFormatString expression that I can use that will force that column to be exported to Excel as text.I have also thought about changing the SQL statement to so the job number is definitely a string by concatenating using ‘J’ + jobnumber as JobNumber but my users don’t want a ‘J’ in front of the job number.Is there a DataFormatString expression for a text string?
View 4 Replies
