What would happen if you call Close() on a SqlConnection object before you call Close() on a SqlDataReader using that connection? Actually, what I really want to know is whether or not the order in which you Close them matters. Does calling SqlConnection.Close() completely close the connection, or will it remain open if you do not call...
I am mapping my database tables to my java objects. Generally I name my tables in the plural form in that a table holding books information is called BOOKS. The java object represents however one book and should be called Book. Similarly for AUTHORS/Author etc. On the other hand, its kind of simplistic to give the same to the domain ob...
background: we've got a number of server processes and client apps that are used entirely internally, in a fairly controlled environment. we capture a significant amount of data every day that goes into a couple database machines. most everything is c#, with a few c++ apps. just about every app has some basic (if not extensive) dependen...
since we suffer from creeping degradation in our web application we decided to monitor our application performance and measure individual actions. for example we will measure the duration of each request, the duration of individual actions like editing a customer or creating an appointment, searching for a contract. in most cases the d...
Suppose you have a dense table with an integer primary key, where you know the table will contain 99% of all values from 0 to 1,000,000. A super-efficient way to implement such a table is an array (or a flat file on disk), assuming a fixed record size. Is there a way to achieve similar efficiency using a database? Clarification - When...
Hello. I want to store into the same table, in different columns 2 java.sql.Date objects to their corresponding SQL Datetime. It works fine, but the hour, minute and seconds are truncated. That's documented in the javadoc. For instance having the date: 5/30/2009 14:33:21 AM when inserted in table it is truncated to 5/30/2009 12:00:00 A...
Hi! I have one huge spreadsheet file (1000+ lines) and one postgreSQL table. I need to compare spreadsheet data with postgresql table data and add fill the blank fields in table with data from spreadsheet and add entries not present in db table. Yes, I can convert (via csv) whole spreadsheet into database table. But, there are unique v...
Does anyone know of an open source database proxy where it can serve as an intermediary between a closed-source client application and either a SQL server and/or Oracle database? ...
I want to insert my product's image into a database and then want to get those image on request. please suggest. ...
I have some tables being used with the Borland Database Engine that I need access to in C#. But I don't see the BDE as an available Data Source. Is this because it's not doable or something else. If anyone has any info or links to provide on how this is done I would appreciate it. Thanks ...
Here is my scenario: A dozen of clients reading from memcached-like store. Read-only access 50K gets/sec 99.999% availability 300 million records, 100 bytes each If one of the stores goes down the system should be able to automatically switch to another replica. When it is time for update the system should be able to quickly reload...
I'm currently in the process of building a repository for a project that will be DB intensive (Performance tests have been carried out and caching is needed hence why I'm asking ) The way I've got it set up now is that each object is individually cached, if I want to do a query for them objects I pass the query to the database and retur...
I have a 2 tables: a membership table and mailing list table. [Members] Username Password EmailAddress MailingListOptIn [bit] Planes [bit] Boats [bit] Cars [bit] The fruits columns are user preferences. and [MailingList] EmailAddress MailingListOptIn A mailinglist'er can opt to receive newsletters but may not necessarily be a ...
I'm using a SQLite database to store cover images of books I have in a database. I've got the inserting of BLOBs ok, but when I don't have a cover image for my book I can't seem to get it to insert a null BLOB. I'm using parameters for my insert SQL statement, using ODBC, as shown below: OdbcParameter^ paramCoverImage = gcnew OdbcParam...
I have made a custom report generator for our database (Oracle Berkeley DB engine). Now it's time for me to add more flexibility and I am in dilemma. Do a partial or a fundamental redesign? Lets assume that I have plenty of time. I can only read the database, I don't have the right to modify it. Inspired from Query Anything with SQLi...
I have a simple SQL Server database that we use for conversions. Basically a table with two mor more columns where one value maps to another. We then have processes that use these tables to find matching values and select other values on that row. These values change a lot and we now need a interface for the business users to update the...
I want to write a calendar application. It is really recurring items that throw a wrench in the works for the DB schema. I would love some input on how to organize this. What if a user creates an event, and inputs that it repeats everyone Monday, forever? How could I store all that in the database? I can't create infinite events. Do I s...
I've been talking with someone about the possibility of a iPhone development contract gig. All I really know at this point is that there is a company that wants to make an iPhone app that will hit their internal database. I'm not sure what the database type is( Oracle, MySQL, etc...). I've wanted to know if the database type was Oracle...
I am trying to program a plugin to bbPress (the open source forum software) that will work similar to Hacker News (http://news.ycombinator.com/). Specifically, I want to sort the order of forum-threads (bbPress calls them "topics") using the following algorithm: sort_value = (p - 1) / (t + 2)^1.5 where p = total votes for each topic fr...
What is Index Maintenance and how do I do it? How frequently do I have to do it? What are the benefits? This is related to a transaction table which is subject to frequently modifications; all DML operations will be run on that table. ...