C# - Avoid Slowdowns While Using Off-site Database?
Jan 17, 2011
Website (ASP.NET/C#) hosted at a dedicated hosting company (location 1) Company database (SQL Server) with records of relevant data (location 2). Location 1 & 2 connected through VPN. Customer visiting the website and wanting to pull data from the company database. No possibility of changing the server locations or layout (i.e. moving the website to an in-office server isn't possible).
What I want to do is figure out the best way to handle the data acces in this case, minimizing the need for time-expensive database calls over the VPN.
When a user enters the section of the website needing the DB data, you pull all the needed tables from the database into a in-memory dataset. All subsequent views/updates to the data is done on this dataset. When the user leaves (logout, session timeout, browser closed etc) the dataset gets sent to the SQL server.
If two web visitors are performing updates on the same data, the one finishing up last will have their changes overwriting the first ones. There's also no way of knowing you have the latest data (i.e. if a customer pulls som info on their projects and we update this info while they are viewing them, they won't see these changes PLUS the above overwriting issue will arise).
View 2 Replies
Similar Messages:
Nov 18, 2010
We have a link in our site that pin points to sharepoint documents and we are retreiving some documents files (*.doc). Our sharepoint uses IWA (integrated windows authentication) which is prompted if we're trying to access that documents, unfortunately we don't want to prompt that window to authenticate the user. We need is to create a username and password and authenticate it. how can we do that.
Note* we have 2 server one for our application and the other one is for sharepoint.
View 3 Replies
Jun 15, 2010
I am working at a site not orginally devleoped by me. The problem is that all the pages are working fine and have no problem at my local site. but the site is not showing any content at live site from database. Niether it shows an error for it. How can I find the problem?
View 7 Replies
Aug 31, 2010
Among methods: static variables, viewstate, session and cache for avoiding on loading repeatedly and less making queries to the database. What do you think the best method of the 4 above? I Think Cache is the best one? Or any other methods better in Asp.net 3.5 or higher?
View 3 Replies
Jun 7, 2010
I have a music related ASP.NET web site which caches a lot of static information from the database on the first request.Sometimes, the application is reset and cache is cleared while the application is on heavy load and then all http requests go to the database to retrieve that static data and cache it for other requests.
How can I ensure that only one request go to the database and cache the results, so that other request simply read that info from cache and not needlessly retrieve the same info over and over again.Can I use thread locking? For example, can I do something like lock(this) { db access here }?
View 2 Replies
Oct 22, 2010
Tell me how can i avoid reconnection to database while paging in repeater?
View 1 Replies
Aug 9, 2010
I am currently using the brinkster hosting (Pro Package) but recently they change my hosting to the new one and after that I got an error for sometimes and my session also expired very fast. Below is the feedback from Brinkster.
Thank you for letting us know about your recent experience with your application. From what we are able to find regarding your application problems, they appear to be related to your ms access database. Due to limitations of ms access, you may want to consider updating the database running your website to mysql. A Mysql database is available to your account at no additional charge.
MS access begins to experience issues like database locks (which is what appears to be happening to your application) when there are more than 3 or 4 concurrent connections to the database for reads. MS access is also only able to have one write connection open at any given moment. MS access databases are more susceptible to corruption and data loss than database application built for large application use and Enterprise or corporate use.
When you were hosted on the previous server, your IIS application pool was getting reset many times per day. This action was in effect unlocking your ms access database from its locked state. After we moved you to the new system and raised your memory utilization limit, your application does not receive resets more than one or two times a week. I have lowered your memory utilization from 200 to 100 in an effort to have your application reset more often, unlocking your database if it has began to cause issues.
My question is, do i have a choice to avoid change my database from MS Access to MySQL? Is MS Access database really have such problem as they mension or somethingelse happen on their server?
View 7 Replies
May 16, 2010
i want to change news item along with photo gallery images on my asp.net page daily without using database is there any other way to do that other than using databse How can i do that
View 2 Replies
Nov 22, 2010
I have a very simple app on my local machine that uses the ASP.NET membership provider. This works fine on my local machine.I have published the app to our web server, and I need to know the specifics of setting up the application for asp.net membership to work.I have a basic understanding that it uses an MDF file and somehow connects to a SQL database (SQLEXPRESS I assume on my local machine) which holds the user/role information.
View 1 Replies
Apr 4, 2011
I have a small website that I am building using ASP.NET web pages Razor Syntax. It has an SQL CE 4 database in the App_Data folder. The connection and getting records from the database works fine in pages that are in the root directory and the /Account subdirectory. However when trying to get data from the database in pages that are in other subdirectories, connection to the database does not work. I get an error: Connection string "Database.sdf" was not found.It is using the connection string from the Web.config file in the root directory:
When I tried copying the root Web.config to the subdirectory I get the following error:The entry 'Database' has already been added. (C:UsersNameDocumentsVisual Studio 2010WebSitesSmallWebsitesubdirweb.config line 11).At the moment I'm stumped and can't seem to find an answer either in msdn or google.
View 1 Replies
May 8, 2010
I'm building a very simple ASP.NET MVC site that doesn't require a database and doesn't have user accounts or any other special ASP.NET stuff. When I first created the site with the ASP.NET MVC 1.0 site template in Visual Studio, the web.config page was configured to automatically connect to SQL Server Express as a User Instance.
Can I completely remove this dependency? If so, how do I get rid of all this database stuff?
View 1 Replies
Apr 13, 2010
I think I already know the answer to this but I think you know more than me so best to ask :)I've got a basic .Net 3.5 site using C#, with no database backend.I've had a request for a function to be added to some forms for people to be able to save the forms and come back later to finish them off.Is this possible?I would think not without a database backend to save it too,
View 3 Replies
Jul 19, 2010
Is there a way to be able to create a new database when a company signs up to my site, and be able to use that database when he/she logs in, so for example if company A logs in he uses CompanyA database and if company B logs in he uses Company B database, now they all have the same table structure, just need to figure out a way to use a specific database depending on the user that logs in.
View 2 Replies
May 18, 2010
I've got a really good idea for a service I'd like to create for the web, but since I'm new to ASP.NET I'd like to get everything up and running before I go and buy hosting etc.
What I'm curious about is the database side of things.
I don't quite understand how I can create a datebase on my computer for the sake of testing and practicing (Presumably through mssql server) and then just transfer it to a hosting account when I'm ready.
I guess the main part I don't understand is how can I connect to a database on my computer via my application and then change the connection so that it points to the web version when I'm ready.
I know that when you create the database and include it in your project it's not technically inside your project (Right?), but it just seems that the application is very rigid once you've specified the connection.
View 14 Replies
Oct 2, 2010
I want to create small ecommerce site with sign up and log in pages. there are two categories jeans and T- shirt
I want to create category pages and product pages but I dont understand how to form tables in database means exactly how
many tables required for this application and how all tables are connected to each other ( how to make relationship in tables)
when particular user sign in and select particular pages how it will added in his cart.
View 1 Replies
Jul 4, 2010
I've built an online scheduling system for a local company so that they can have a calendar with the scheduled jobs for the day and so that the customers can check on the progress of the work being done for them. Allowing the customer to check for themselves would cut their phone call volume down to about 30% of what it is now leaving more time to complete jobs. Everything is fine but I'm concerned about instances when either the server has issues or the business' internet is down. I was considering making it a desktop application but then it wouldn't have the online abilities of allowing the customers to check on the job's progress.
So, basically, as it stands now, if there is problems with the internet connection, either at the business or at the host, the business loses their daily scheduler and if I make it a desktop app the customer has to call to check on the progress. Unless I can make the local database copy any transaction made on the desktop app to the database on the server. How would I go about doing something like that? Would this be a good reason to use a web service (something I've never done)?
View 12 Replies
Jun 1, 2010
I just set up user profiles using asp.net 3.5 using wvd. For each user I would like to store data that they will be updating every day. For example, every time they go for a run they will update time and distance. I intend to allow them to also look up their history of distance and time from any past date. My question is, what does the database schema usually look like for such a set up? Currently asp.net set up a db for me when I made user profiles. Do I just add an extra table for every user? Should there be one big table with all users data? How do I relate a user I'd to their specific data? Etc.
View 2 Replies
Apr 18, 2010
I want to have site.sitemap file that is build runtime from my sql database.
View 2 Replies
Sep 27, 2010
I have an SQL 2008 DB and I need to transfer the structure and the data to an off site, off network database. I need to somehow create a physical file that represents the structure and data within the db that can be loaded in another instance of SQL Server 2008.
View 1 Replies
Aug 2, 2010
I´m about to program a common application/website scenario. It contains pages which are presented to users, and some business logic behind, with a database connection class.
My questions are:
Q1: Should the database class be singleton? If so, why? Because does it even matter when every single user is in their own process on the server, and therefore each user has their "own" singleton database instance?
Q2: How would you normally direct users around the site? Would the Default.aspx page create instances of the required classes? And when the user is directed to a new page, how would you normally refer to these instances?
Q3: What kind of general information do you save in the Session variable? Is it a big no-no to save class instances?
View 1 Replies
Mar 19, 2013
How to develop side with 20 different local language in india using sql database. the content are coming from database only. and when i select the language from dropdown it should convert this database text to appropriate language.
View 1 Replies
Sep 6, 2010
how to connect database create in sql server ,to my web site upload on domain.
View 1 Replies
May 11, 2010
This will be my first time trying to upload a ASP.NET site. I would like to upload my site by simply using ftp and transferring the contents of the project directory so that the site will be easy for me to make future updates. Where can I find directions for uploading a ASP.NET site via ftp? I am assuming that I will need to edit the connection string in the web.config file. However, my hosting company told me to just make a full backup of of the database into .BAK file format and upload it via FTP to your the "private" folder. Anyone have any experience with something like this and can tell me how this would affect the connection string? Can I back up the database to a .BAK file from within Visual Studio 2008 or do I have to use Management Studio? I am using Visual Studio 2008 with ASP.NET 3.5, C#, and SQL Server 2008 Express Edition.
View 1 Replies
Dec 26, 2010
I try to create a wordpress site from the gallery and I get an error that says that it cannot find database. I dont have mySQL installed. I thought that WebMatrix would download and install it. Does WebMatrix Beta 3 expect MySQL to be installed? And if so, which version?
View 1 Replies
Mar 16, 2010
How difficult is it going to be for me to pick up ASP. I dont know any coding besides basic HTML.
My end goal is to create a site with a form that will be linked to a database. The user entered information will pull data and display it to them.I have the SQL query, I just need to write the sit
View 4 Replies
