We are building a new application in .net 3.5 with SQL server database. The database is fairly large having around 60 tables with loads on data. The .net application have functionality to bring data into this database from data entry and from third party systems. After all the data is available in database the system have to do lots of ...
Im am writing an application for the JBOSS JEE-Server. I would like to have the DB-access code quite robust. Thus I have created retry loops so that the request won't fail because of temporary network problems. Now I would like the execution of the request to pause in between retries. The server thread has been spawned by a request to a...
I'm looking for a performance tool for testing of load in terms of data and number of users. This tool must support Oracle and MySQL. PS: I've tried DBtuna and Spotlight. ...
This query seems to be running incredibly slow (25 seconds for 4 million records!) on Sybase v10 at a clients database: Select max(tnr) from myTable; With tnr being the primary key. If I run it 1000x on our server however, it seems to go fast (15 ms...) which makes me think it's because the query result is cached. Is there a way to d...
I have an informix database consisting of a large number of tables. I know that there is a string "example" somewhere inside some table, but don't know which table it is or which column it is. (I know this is a very rare case) Because of the large number of tables, there is no way to look for it manually. How do i find this value insid...
I'm curious for technical reasons why you choose Oracle database versus the latest flavors of: 1) Microsoft SQL Server 2) MySQL 3) PostgreSQL What features or functionality justify the extra cost. I'm interested in technical arguments, not a religious war. A friend asked me this and I've always used one of the 3 I listed. I didn't kn...
We have a system that uses UniqueIdentifier as the primary key of each of the tables. It has been brought to our attention that this is a bad idea. I have seen similar post on the subject but I am interested in any MS SQL performance and other potential problems I may encounter due to this decision. ...
I'm looking at implementing an RDBMS. Are there any good resources out there about how a database works internally, and the kinds of things I'd need to know when starting out to build my own? (Please no comments about whether it's a practical idea or not - just imagine it's for a hobby project or something). Again - interested in the ...
Rules like "A parent object will have up to 2 children" could be enforced in database using triggers. But would it be a good idea to duplicate the rule if this rule is already enforced in the domain layer. In which cases duplication of such rules are justified? Are there any alternative to avoid such duplication? Is it not a data integ...
Some context for the question All objects in this question are persistent. All requests will be from a Silverlight client talking to an app server via a binary protocol (Hessian) and not WCF. Each user will have a session key (not an ASP.NET session) which will be a string, integer, or GUID (undecided so far). Some objects might ta...
I want to store times in a database table but only need to store the hours and minutes. I know I could just use DATETIME and ignore the other components of the date, but what's the best way to do this without storing more info than I actually need? ...
Hi, I'm using CakePHP with $modelName->find(...) calls to select quite a number of rows (could be hundreds) Normally, in PHP/MySQL of course this wouldn't be a problem, as you fetch them in a while loop. But, CakePHP loads all rows in to an array which exhausts the memory limit. Is there a way to use the $modelName->find(...) construc...
I have a "copy" stored procedure for a database. During the copy, I backup the database with something like: exec('backup database [' + @source + '] ' + 'to disk = N''' + @backupdir + '\copybackup'' ' + 'with noformat, noinit, name=N''copybackup-full'', ' + 'SKIP, NOREWIND, NOUNLOAD, STATS = 10;'); And then create and emp...
Has anybody done any benchmarking/evaluation of the popular open-source embedded SQL DBs for performance, particularly write performance? I've some 1:1 comparisons for sqlite, Firebird Embedded, Derby and HSQLDB (others I am missing?) but no across the board comparisons... Also, I'd be interested in the overall developer experience for ...
What is a KISS (Keep it Simple, Stupid) way to remember what Boyce-Codd normal form is and how to take a unnormalized table and BCNF it? Wikipedia's info: not terribly helpful for me. ...
My software went in production some days ago and now I want to argue a bit about the database structure. The software collects data about ships, currently 174 details for each ship, each detail can be a text value, a long text value, a number (of a specified length, with or without a specified number of decimals), a date, a date with ti...
Hi, I have a database efficiency question. Here is some info about my table: -table of about 500-1000 records -records are added and deleted every day. - usually have about the same amount being added and deleted every day (size of active records stays the same) Now, my question is.....when I delete records,...should I (A) delete the...
I have a large database and want to implement a feature which would allow a user to do a bulk update of information. The user downloads an excel file, makes the changes and the system accepts the excel file. The user uses a web interface (ASP.NET) to download the data from database to Excel. User modifies the Excel file. Only certain d...
Hi, This may be a little naive but I just want check my way of doing this is correct. I receive a collection of objects from the UI. I then wish to check those objects against the records in the db. This is what I am doing to Create Update and Delete the received objects. Loop trough received objects - if (id == 0 ) create new record...
Has anybody ever used or have useful comments on Itzam/core? I am attracted to it partly because I was impressed by the author's book C++ Components & Algorithms and as a possible backend for my search for a large non-SQL portable database engine. ...