The application we have takes large amount of data most of which is called transactions which is mostly clock in and clock out information of employees,most of which is processed and stored in an other table.Over years this data may grow.I was thinking of backup data to text files and export them if ever from those text files,export will...
My task ahead is to insert a giant amount of data into a document-oriented DB (any one of them) and have it be full-text searchable as a whole (on all or any field). Do I have to use a DB and a separate full-text search index like Solr or are there document-oriented DBs with fulltext search kind of built-in? ...
There are a lot of questions about salts and best practices, however most of them simply answer very specific questions about them. I have several questions which feed into one another. Assuming a database is compromised a per user salt prevents the use of generic rainbow tables to crack passwords. A separate rainbow table would have ...
We have a set of services in .NET 3.5\C# and WCF. The NUnit tests need the services to be running and listening for requests. The services need an updated SQL database to be ready for connection. Currently the [SetUp] section of the unit test does two tasks: Execute the latest SQL scripts to build the database. Utilize a System.Diagn...
so basically here's what i want to do: i have an account table, i have a list of acct_id: (3, 24, 515, 6326, 17), assuming i have about 100,000 accounts in the table, what's the most effective way to delete all the other rows besides the one with the account_id in my given list? i came up with something like: delete from account where ...
Hello, Two questions: If I remove all the data inside a collection (db.mycollection.remove({})) will the indexing information I created previously be lost? How often (how many more entries must I have) should I recreate the index? Thank you ...
In brief, what happens when you add a column to a table? What happens when you remove one? In more details, suppose you have the following: class User extends Doctrine_Record { public function setTableDefinition() { $this->hasColumn('username', 'string', 255); $this->hasColumn('password', 'string', 255); } }...
Anyone know when the MySQL 6 release date is? I've seen a ton of alpha/beta for it but have not seen an actual release date for 6.0 Looks like back in April, MySQL announced the release of ALPHA version 6.0.11. In that release back in April 2009 they stated that this would be the last ALPHA release and the next release in Sept 2009 wou...
Has anyone used the TokuDB storage engine for MySQL? The product web site claims to have a 50x performance increase over other MySQL storage engines (e.g. Innodb, MyISAM, etc). Here are the performance claims http://tokutek.com/downloads/tokudb-performance-brief.pdf Is this true? Any personal experiences with this storage engine in us...
I am just getting started breaking a .NET application and its SQL Server database into two systems - an intranet and a public website. The various database tables will need to be synchronised between the two databases in different ways, for example: Moving from web to intranet, with the intranet data becoming read-only Moving from int...
i am trying to merge similar data together but choosen data. for example the table has 5 rows and i want 3 rows which have similar data to merge. other 2 rows, even though it contains similar data, i dont want it to merge. is there a way to do this? here is my current code: protected void DataBoundModuleGV(object sender, Even...
In my project i need to switch between databases during runtime. I tried to use Hibernate, but stuck in a place, where i need to map object with table in database. The problem is, that i have several tables with prefix: documents2001, documents2002 ... As i understood, i can't map class with table during runtime. I tried using iBatis, bu...
Hi I have the following code in my change.php page: $con = mysql_connect("localhost","root","root"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("FACT", $con); if($_POST['isChecked']==1) // SEE THIS LINE PLEASE { mysql_query("UPDATE Orc SET CON = 'CHECKED' WHERE UID = '1'"); } ...
I have been investigating some performance issues with my database (SQL Server 2008). SQL Management studio suggested that I use this code to add a nonclustered index which will decrease processing time by over 90%. USE [DatabaseName] GO CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>] ON [dbo].[tblAnswers] ([QuestionID]) ...
I'm interested in what is the potential of SQL Server when it comes to volume of data (size of the database, number of rows, etc.). ...
How can I make it so that content from a database is available to search engines, like google, for indexing? Example: Table in mysql has a field named 'Headline' which equals 'BMW M3 2005'. My site name is 'MySite' User enters 'BMW M3 2005 MySite' in google and the record will show up with results? ...
Hi, I'm planning to code a Web2 online application and I'm looking for best-pratices. I'm talking about online apps similar to web collaborative or billing apps. In fact I'm wondering how they setup their DB? Do they put all users info in the same DB, is each user have their own DB? Any suggestion and information are welcome! Tha...
Hello, I'm creating a page where I want to make a history page. So I was wondering if there is any way to fetch all rows from multiple tables and then sort by their time? Every table has a field called "created_at". So is there any way to fetch from all tables and sort without having Rails sorting them form me? ...
I've the following category structure: - Transport (10) - Cars (5) - Audi (2) - BMW (3) - ... - Spare Parts (5) - Audi (5) - Audi glass (1) - Carburetors (4) - Mirrors - ... - Buses - Spare Parts (5) - Audi (5) - Audi glass (1...
For unit tests, demonstrations and Hibernate tasks I would like to use a small and simple Java database like Derby / Java DB or HSQLDB, which can be called from within Maven. So far I have not found a Maven plugin which can download and launch Java DB (which is my favorite at the moment) or something similar. ...