Hi! I have a website (www.soltrago.com) wghere I use a .mdb microsoft access database to retrieve data when the pages loads. I use a dns less connection to connect to the database. My question is how many simultaneous connections can I have to my webpage? Like how many people per second can view my webpage? Thanks! ...
I am using the Ado.Net Entity Framework with ASP.NET MVC. In my MSSQL 2008 Database I have for example the following simplified tables and relations: (Song) 1--* (Version) 1 -- 1 (VersionInfo) Is it possible to automatically have the linked Versions and their VersionInfo's deleted when I delete a Song? Currently I am using somethin...
I am currently into a performance tuning exercise. The application is DB intensive with very little processing logic. The performance tuning is around the way DB calls are made and the DB itself. We did the query tuning, We put the missing indexes, We reduced or eliminated DB calls where possible. The application is performing very well...
Hi all – I'm currently working on a problem that involves querying a tremendous amount of data (billions of rows) and, being somewhat inexperienced with this type of thing, would love some clever advice. The data/problem looks like this: Each table has 2-5 key columns and 1 value column. Every row has a unique combination of keys. I ...
Sorry for the dumb question as I'm a newbie. If I wanted to build a commercial Windows application (one I'll sell for $), what are my options in terms of an embedded datastore? Would I use MSDE? Is this something that I'd bundle with my app? Are there other options (both from MS as well as other vendors)? Do you have to pay a fee to...
objective: to install oracle 10g xe on ubuntu. method followed :www.oracle.com/technology/tech/linux/install/xe-on-kubuntu.html problem: The installation went fine and at 1 point it asked me for a password for the system account and I gave it lets say 'securepassword' that. Now, I have 2 problems: I want to create a database. There is ...
Righteo, Just started messing with Jquery, and I can update a database etc with it, but I want to know if there is a way to display new info posted into a database (even if it is not what was just posted) without a reload etc. Don't write it out for me, just point me in the right direction... I want to pull it together myself.. best way...
I'm developing a web app using Django, and I'll need to add search functionality soon. Search will be implemented for two models, one being an extension of the auth user class and another one with the fields name, tags, and description. So I guess nothing too scary here in context of searching text. For development I am using SQLite and...
(Actual site names have been changed) I installed drupal on elephantboarding.com, and it is under version control. I svn updated in landonwinters.com/elephantboarding after i svn committed the installation in megafishoil.com. But landonwinters.com/elephantboarding looks weird, like it doesn't have the default theme set up right, it's ...
I want to secure events stored in one table, which has relations to others. Events are inserted through windows service, that is connecting to hardware and reading from the hardware. In events table is PK, date and time, and 3 different values. The problem is that every admin can log in and insert/update/delete data in this table e.g...
Suppose it is a long article (say 100,000 words), and I need to write a PHP file to display page 1, 2, or page 38 of the article, by display.php?page=38 but the number of words for each page can change over time (for example, right now if it is 500 words per page, but next month, we can change it to 300 words per page easily). What i...
This is more out of curiosity and "for future reference" than anything, but how is Comet implemented on the database-side? I know most implementations use long-lived HTTP requests to "wait" until data is available, but how is this done on the server-side? How does the web server know when new data is available? Does it constantly poll th...
I love the abstract database API that comes with Django, I was wondering if I could use this (or something similar) to model, access, and manage my (postgres) database for my non-Django Python projects. ...
Possible Duplicate: What to do when I want to use database constraints but only mark as deleted instead of deleting? Is it more appropriate to set some kind of "IsDeleted" flag in a heavily used database to simply mark records for deletion (and then delete them later), or should they be deleted directly? I like the IsDeleted f...
What are the general rules in regards to using composite indexes? When should you use them, and when should you avoid them? ...
I recently perform a purging on my application table. total record of 1.1 millions with the disk space used 11.12GB. I had deleted 860k records and remain 290k records, but why my space used only drop to 11.09GB? I monitor the detail on report - disk usage - disk space used by data files - space used. Is it that i need to perfrom sh...
When designing a schema for a DB (e.g. MySQL) the question arises whether or not to completely normalize the tables. On one hand joins (and foreign key constraints, etc.) are very slow, and on the other hand you get redundant data and the potential for inconsistency. Is "optimize last" the correct approach here? i.e. create a by-the-bo...
I want to generate unique hexadecimal numbers in SQL. How can I do this? If you know how to generate in c# please also include that. ...
DB Table: id int(6) message char(5) I have to add a record (message) to the DB table. In case of duplicate message(this message already exists with different id) I want to delete (or inactivate somehow) the both of the messages and get their ID's in reply. Is it possible to perform with only one query? Any performance tips ?.....
Hello, I'm overseeing the overhaul an asp.old web app for order entry into .net. So far easy enough, the project has taken an interesting turn, in that I also need to ensure that it can support data entry of Chinese text. Am just looking at data entry for now. I've hit a snag in that there are conditions when data entry must only be a...