I have one desktop application which is maintain all information related to laws of high court. we have stored lots of data in my application and now
our database size is almost 40 GB.
So my application runs quite slow.
How can i reduce the database space on my hard disk.
I want decrease my database's file size I mean I want decrease .ldf and .mdf file's size... How I can do it?
View 1 RepliesIn my application image size is comming as 99999 in byte.so that i m unable to view my page because its too large.
so i want to decrease that size.
iam using asp.net with c#,
i want to remove browse text and decrease the size browse button of fileupload control in asp.net
i want to place like dot .... like symbol in place of browse text and decrease the size of browse button .
Can anybody tell me how can I increase the size of the database in oracle manually.
View 2 RepliesIm working on my first ASPX webpage now, and Im wondering if there is some way to make a cache?
With a cache, I mean a list of variables that gets transferred from a db to for insance a hashtable the first time a user loads the page. When the next user loads the page, the db doesent get touched, but the variable is collected from the hashtable.
I tried to make a static class, but it re-loaded for each time I refreshed the page.
how to create variable with max size in pls/sql function
View 2 Repliesprotected void Button3_Click(object sender, EventArgs e)
{
//Create a connection to the database
MySqlConnection conn = new MySqlConnection("Database=kid07025;Data Source=195.178.228.254;User Id=kid07025;Password=********");
//open the connection
conn.Open();
//MySQL Query which updates the row where Anvandarnamn = Anvandarnamn (recieved from a cookie)
MySqlCommand cmd = new MySqlCommand("UPDATE personer SET Information=?Information,Fnamn=?Fnamn,Enamn=?Enamn,Personnr=?Personnr,Adress=?Adress,Postnr=?Postnr,Ort=?Ort WHERE Anvandarnamn=?Anvandarnamn", conn);
// Update with new text
cmd.Parameters.AddWithValue("?Anvandarnamn", Request.Cookies["Anvandarnamn"].Value);
cmd.Parameters.AddWithValue("?Information", TextBox1.Text);
cmd.Parameters.AddWithValue("?Fnamn", TextBox2.Text);
cmd.Parameters.AddWithValue("?Enamn", TextBox3.Text);
cmd.Parameters.AddWithValue("?Personnr",TextBox4.Text);
cmd.Parameters.AddWithValue("?Adress", TextBox5.Text);
cmd.Parameters.AddWithValue("?Postnr", TextBox6.Text);
cmd.Parameters.AddWithValue("?Ort", TextBox7.Text);
cmd.ExecuteReader();
conn.Close();
RefreshProfile();
}
I don't know what I am doing wrong here, but the database doesn't get updated when I press the button.
I use VS 2010, ASP.NET
I'm working with Oracle database and I want to improve performance of my website.I read about caching. So is it possible to implement caching (SQL Server Database Dependency) with oracle?
View 2 RepliesWeb forms .NET application, is starting to meet 64 bits Windows servers and we have a 32bit DLL from one of our component vendors (its a hardware key, actually). I checked the instructions here "compiling a .net application with either a 32-bit or 64-bit dll". It is also what our vendor sugested. question: is there a performance impact on compiling a web application to run on x86 mode ?Please don't flame me for using a hardware key
View 1 RepliesI have an ASP.net MVC 2 application that runs well locally. However when I move the files to my production server, I get a first time lag of about 30 seconds, I assume this is a first compile. After that the application works fine. Then after about 20-30 minutes of non use, the applications takes another 30 seconds or so to load.
I did try to precompile the code, but there is still a lag during the first load.
Are there any trick to getting the application to work faster on the first load?
I am using ASP.net 3.5, IIS 6 , visual studio 2010, MVC 2.
how to decrease the width of the crystal report in asp.net
View 1 RepliesI have an application that allows users to upload a pdf. I am saving the PDF into SQL (I know already this is not the best practice, but it was not my decision) and I need to some how duing this upload process reduce the size of the pdf. Is there a way to get the uploaded file, reduce its size, then stream it to SQL?
View 12 RepliesHow to decrease the page load time in ASP.NET application? What should be the precautions and specially when we are interacting with databases
e.g.
wise use of viewstate
Set in web.config when deploying the app
etc
I have some difficulties in one of the web based projects that I've developed.
It's a country wide project and database is big, so the waiting time is getting increasing. I tried to write non- complex queries and set up index on some important fields that are being searched as well.
Is there any other way to enhance the efficiency and performance?
I have a database that I just migrated data to. It has grown to 769MB from 13MB when I shrink it, it does not get any smaller. I don't think the amount of data should have made it grow that much. Could I be doing something wrong?
View 3 RepliesIf i have created 1 database. then what would be the max size of that database in sql server 2000 & Sql server 2005?
View 3 RepliesI have stored images in folder each images is more than 700kb so datalist binding process became slow.so it is possible that while loading record and corresponding images from folders Can I reduce the image size or compress images so that record fetching become faster.In database i m stroing image path and image is stored in directory.
View 1 RepliesI m doing paging in gridview. The paging one which acts like footer is of more height. I m trying to decrease the height but it is not working. when I m trying to increase it working.
View 3 RepliesI an developing a asp.net website using c#.can anybody suggest how to decrease the load in a lot of users simulteniously visit on my side
View 4 Replieshow to pass font size value to label from database column?
View 3 RepliesWhen I initially created my SQL Express 2008 database I vastly over-estimated the size of my database files. The problem is that now I have the correct field sizes and data actually in the database it does not require the max file sizes and growth that I had originally set.
This is a problem as I have a max database size of 500Mb with my web hosting provider and it appears that my database now has too large a footprint. This is after I have used the shrink database command in SQL Server Management and shrunk the database to a size of 6Mb so I can only presume that the problem lies with the fact that my original file size / growth settings are taking my database size to well over the 500Mb threshold I am permitted.
Is there anyway for me to change the max file size and growth options of my database without having to recreate the database from scratch?
I know the content palcehlder does not have a size ,I have a masterpage and content page, the master page has a table with a header, content area, and footer, header and footer are fixed size, content area is 100%. As the user sizes the browser the content area grows and shrinks and the footer stays at the
bottom of the browser window - perfect!
Problem: The contentpalceholder does not grow to fill the available content area. Now, the contentplaceholder gets its size from its contents, which in this case is a div holding a silverlight object.I was thinking I could hook the master or child page's re-size event and somehow pass that info onto the SL object, but as it turns out (and I'm surprised I never knew this) there is no aps.net page re-size event! (really?, wow.)
So is there a way to get a SL object hosted on a master page to size itself based on the size of the browser window?Or more generally, a way to size the contents (like a div or panel) of a contentplaceholder based on the browser? on a standard aspx page (not a master page) I CAN get the SL object to size itself based on the broswer, the problem seems to come from the fact that I'm hosting the SL object in a content placeholder.
I guess I could 'unroll' the master page into several standalone pages and have it work, but the menu is on the master page and I'm used to using them, plus it's already done...<sigh>
I am getting following error ...when trying to do any operation....
"The transaction log for database 'MyDatabase' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc
column in sys.databases"
I tried to shirnk file log file using ...
dbcc shrinkfile(EMRSET_log,1) But still same issue....And its show ...
DBName 4 ACTIVE_TRANSACTION (log_reuse_wait, log_reuse_wait_desc) ...
What steps i do to resolve this issue. Using MS SQL 2008
I am using TabContainer with some controls on each tab (asp: labels, text boxes). When redirecting to the page that contains the TabContainer, the tabs and their content loads as expected, but when there is a postback, and the page refreshes, the TabContainer UI changes - the font size of the labels gets bigger, the text boxes become bigger and their location changes a bit (not aligned as before), and the tab header is partially hidden. I am using IE7.
I dont know if this is relevant but in some of the text boxes i use edit mask extender as well for date. Also, I have used a table inside the TabContainer for layouting the controls.