I have a view that collects data from several tables. While there are no indexes on the view itself anything that uses the view seems to benefit from the underlying tables having indexes. Are these being used automatically? If they are then what is the point of creating indexes on your views? Any recommended articles on this subject ...
Hello. I am planning to deploy my web application (ASP.Net based) on the Amazon EC2 and the persistence on Amazon RDS. I have a 'gut feeling' that at least my session store (again on RDS) should be separate from the rest of the application database. This is because I am expecting high activity in the session store. RDS supports the abili...
I'd like to be able to log message information in a database, and I'm trying to decide how best to do that. Is it possible to configure the WCF logging mechanisms to write to a database instead of a file? Thanks. ...
I am looking for the best MySQL client for my iPhone. I see several like Flipper and iMy and several others, but before I invest a bunch of time and a little money trying them out, I would like to just start with the best most feature rich one. I would link to the others but don't have permission yet. ...
Hello. I have a staging database which stores the GEO location as the following structure : Countries Regions Cities Postal Code Longtitude Latitude I am getting the data from a vendor. The name is not relevant. The data comes in a CSV file, the columns are Start IP End IP Country Region City Postal Code Longtitude Latitude The fac...
I have a PostgreSQL database whose tables are divided amongst a number of schemas. Each schema has a different set of access controls; for example, one schema might be read-only to regular users, while they are allowed to create tables on another. Schemas also act as namespaces, so users don't have to worry about duplicating existing t...
I've a MySQL InnoDB table with 1,000,000 records. Is this too much? Or databases can handle this and more? I ask because I noticed that some queries (for example, getting the last row from a table) are slower (seconds) in the table with 1 millon rows than in one with 100. ...
Here the deal: I've got a table Billing, which is basically a receipt (for different types of transaction). The app has a feature that you can create new charges (well, all charges except for tax and other constants). Since there would be a dynamic number of charges, we decided to store the charges for a billing on a single text field wi...
Hi, Is it possible to mirror 3 databases on 2 servers, ie. On server 1 database1, database2, database3 On server 2 mirrored database1, database2, database3 My admin claims due to endpoints its not possible to mirror 3 dbs from 1 server to another and one must use 3 servers each with 1 db... Any help appreciated, also links ...
Hello guys I'd like to know if it is any kind of issue having 200+ MySQL databases on the same server. None of them are probably going to be very used, I'm just wondering if there is any issue having so much databases. Thanks in advance ...
Let's say we have a [Valuations] table containing several values per date and per fund: -FundId -ValDate -Value1 -Value2... The Primary key is obviously FundId+ValDate. I have also indexed the ValDate field since I often query for values on a specific date. My question is: should I also create a specific index for the FundId, or i...
I have a procedure written in PLJava that sends out updates over JMS in my postgres database. What I would like to do is have that function called on an interval (every 15 seconds) internally in the database (preferably not from an outside process). Is this possible? Any ideas? ...
I have a query that requires a where statement on a calculated value: select * from table where date( timestamp ) = ? An explain on this query yields the expected ALL select type, which is not ideal. Using MySQL, what's the best way to optimize this? ...
I have a question about where values in dropdowns are coming from: I have a migration that set up the original table with some initial values: add_column :contracts, :signature_status_id, :integer # lookup data sig = SignatureStatus.new(:name => "Delivered") sig.save! sig = SignatureStatus.new(:name => "Signed") sig.save! I have a t...
I need a way to tell if it's a user's first time to log in--so I can display relevant information to that user about what they need to do. How can this be achieved? I'm at a loss here and examples would be appreciated! :) ...
Hi all, It there a tool for django to install some static data (necessary data to have application runing ) to database? ./manage.py syncdb will make the database schema i db, some tool for pushing static data to db ? Thanks ...
i have a table called orders. one column on order is customer_id i have a table called customers with 10 fields Given the two options if i want to build up an array of order objects and embedded in an order object is a customer object i have two choices. Option 1: a. first query orders table. b. loop through records and query the pe...
Are there any DBs for Java that can be run in an embedded mode with some tables being stored in-memory while loading others from disk? H2 and JavaDB seem to be the two leaders for Java DBs and I know they both have an in-memory mode, but do they make you load the whole DB into memory or can you decide on a table-by-table basis? ...
When a filed is INT(data type), what should I choose as collation in MySQL? ...
Hi I have a region table in which I store master region data like Europe, America. etc. Now, in the region drop down in the UI I want to add an option to select all regions. Should i add a new record "ALL" in the region table or should I add the "ALL" option only in the UI? Also in the JSP (UI) i retrieve the region from DB (EJB) and...