I have a mysql db with 10 tables. Each table drives a website where users can look at or submit data to that table. Now the more popular tables have stopped displaying new data (checking through phpmyadmin). The smaller tables are still working fine. I don't get any errors when submitting. The data just doesn't show up in the databas...
Hi I was reading about temporal databases and it seems they have built in time aspects. I wonder why would we need such a model? How different is it from a normal RDBMS? Can't we have a normal database i.e. RDBMS and say have a trigger which associates a time stamp with each transaction that happens? May be there would be a performance...
I have a very large dataset, each item in the dataset being roughly 1kB in size. The data needs to be queried rapidly by many applications distributed over a network. The dataset has more than a million items (so 500 million+ 1kB data chunks). What would be the best method to storing this dataset (need to allow adding more items, and r...
Can you please forward me the answer for my oracle project? I have two different tables, invoice and customer. In the invoice table I already have a column called date and in the customer table I don't have the date column and I already created. I don't know how to bring the date data from the invoice table. Can anyone answer this quest...
We want to use GML in our application; It is a GIS based application which simulates the real word objects (i.e. Pipes, Roads, etc) in a virtual reality environment. Currently we draw and store the geometry in AutoCAD DWGs but in future we want to change the Database. I really need to find the answers of these questions. 1- Is GML prope...
I have a database that needs to be able to scale up to billions of entries or rows. Can this many rows be supported per single table? Is it advisable? Would a single table be split over several clusters if used in a NDBCLUSTER. Other load balancing techniques? What are some advisable methods of deploying such a database? What are be...
Does anyone know what the complexity is for the SQL LIKE operator for the most popular databases? ...
I want to select the top N rows of a table, ranked by how high the number in one of their columns is. I already have: SELECT * FROM movie ORDER BY worldwide_gross DESC; How can I get the first twenty? If it makes any difference I'm using MySQL. Cheers! ...
I ran a lookup test against an indexed MySQL table containing 20,000,000 records, and according to my results, it takes 0.004 seconds to retrieve a record given an id--even when joining against another table containing 4,000 records. This was on a 3GHz dual-core machine, with only one user (me) accessing the database. Writes were also fa...
Right now I have two fields for cost. One for dollars and one for cents. This works, but it is a bit ugly. It also doesn't allow the user to enter the term "free" or "no cost" if they want. But if I only have one field, I might have to make my parser a bit smarter. What do you think? On the server side, I combine dollars and cents t...
Background: I've got a bunch of strings that I'm getting from a database, and I want to return them. Traditionally, it would be something like this: public List<string> GetStuff(string connectionString) { List<string> categoryList = new List<string>(); using (SqlConnection sqlConnection = new SqlConnection(connectionString)) ...
A Report can have multiple charts. The Chart table looks as follows: Chart -- Id, ChartId, ReportId, ... The ChartId above can map to the ChartId to either one of the following Chart Types: Line: ChartId, Thickness, YAxis, XAxis, Color, ... Pie: ChartId, Radius, Color, ... Bar: ChartId, Width, Color, Border, ... I am using SQL Se...
I am looking for a reasonably well tested library+server to store a persistent distributed hash table. I am hesistant to use SQL-based solutions as the data is highly document oriented, consisting of millions of ~64KB blobs with only a single index (computed by hash of said BLOB) - and needs to be able to be distributed for long term s...
Suppose we have two tables. Post and Comment. Post has many Comments. Pretend they are somewhat filled so that the number of comments per post is varied. I want a query which will grab all posts but only the newest comment per post. I have been directed to joins and sub queries but I can't figure it out. Example Output: Post1: Comment...
I am trying to import a CSV file into MySQL 5.0 with the following line: LOAD DATA LOCAL INFILE 'file' INTO TABLE MYTABLE FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\\' My table schema is as follows CREATE TABLE AUCTIONS ( ARTICLE_NO VARCHAR(20), ARTICLE_NAME VARCHAR(100), SUBTITLE VARCHAR(20), CURREN...
I want recommendations on an easy to learn tool or programming language to develop web based applications. It should provide rapid application development (RAD), be cross platform and able to connect to various databases. An example could be Ruby, TurboGears etc. Preferably open source. ...
In most cases i am used ti work with Windows, some weeks ago i started to work with Oracle, i have experience with other DBMS like SQL and MySql and I have worked with them in Windows. Now i am learning Oracle and i dont know in which OS oracle works better. I have installed it in windows but not in Linux. Also i downloaded the Oracle En...
Possible Duplicate: Storing Images in DB - Yea or Nay? Duplicate: http://stackoverflow.com/questions/766048/store-image-in-database-or-in-a-system-file http://stackoverflow.com/questions/713243/should-i-store-my-images-in-the-database-or-folders http://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay Hi, ...
I am not professional programmer so i can not be sure about this.How many mysql queries your scripts send at one page and what is your optimal query number .For example at stackoverflow's homepage it lists questions shows authors of these questions . is stackoverflow sends mysql query foreach question to get information of author. or...
I am writing a distributed DB Application with an Access Front end. Essentially an mde with some forms and reports. Should I use an access mdb to hold the backend tables or use MySQL or some other database? ...