I have a mySQL database running on a server on the local network. If I make a normal SELECT statement, I get 6000 results. The execution time in the mySQL query browser is 0.35s, but the data is received and shown in query browser after 9s. I have the same problem if I try to access the data through the .NET application. The query its...
Say you retrieve 100 records, and display them on a page. The user only updates 2 of the records on the page. Now you want to update only the two records, and not the other 98. Is it best to have one submit on the page, then somehow know which 2 are updated, then send only those two to the db for an update? What does the "somehow" look ...
I have code that depends a relatively small MS Jet (created in Access) database. Our source control process is far from all that it could/should be (which is a problem that needs to be solved immediately) and we have ended up with two versions of the same database. The person who edited the "other" version is no longer around to give me ...
Hi I would like to know if there is any other way using javascript or something to enter the user input directly to database without using POST method. ...
I'm planning on making a distributed database system using a shared-nothing architecture and multiversion concurrency control. Redundancy will be achieved through asynchronous replication (it's allowed to lose some recent changes in case of a failure, as long as the data in the system remains consistent). For each database entry, one nod...
I'm using SqlServer to drive a WPF application, I'm currently using NHibernate and pre-read all the data so it's cached for performance reasons. That works for a single client app, but I was wondering if there's an in memory database that I could use so I can share the information across multiple apps on the same machine. Ideally this wo...
How would you structure the information which you maintain to keep all of the information about your projects and clients at your fingertips. We are finding that ours is becoming so large that at times we don't know for sure what we are looking for only that we know it is in the knowledge-base. We use a confluence in a classical hierarch...
I have been trying for the past several hours to find a working method of accessing a mysql database in python. The only thing that I've managed to get to compile and install is pyodbc but the necessary driver is not available for ppc leopard. I already know about this. UPDATE: I've gotten setuptools to install, but now MySQL-python ...
have anyone used this before, i need free country, city, IP database for sqlserver ...
What is the recommended way to return ad hoc (custom case by case) data from repository which don't fit any model entities or which extend some? The 101 example would be the ubiquitous hello word application: a blog system. Suppose you want to load a list of posts where post entry has some additional information which does not exists in...
What are common database development mistakes made by application developers? ...
Hi, I'm learning PHP and MySQL and I'm creating a movies website for learning purposes. I want to insert variables and arrays containing movie info into a database but in different tables. This is what I have right now: include('inc/connection.php'); $conn = dbConnect(); // create SQL $sql = 'INSERT INTO movies (movieid, title, year,...
I have an as400 table containing roughly 1 million rows of full names / company names which I would like to convert to use another datastore while still matching the speed of the original. Currently, a user enters the search and almost instantaneously gets the alphabetical position of the search term in the table and and a page of mat...
Is there a way to develop Bi (Business Intelligence) solutions with Django? Therefore it should be possible to define models with more than one Datasource. Is anybody out there who has experienced BI with Django? How could it work ? ...
How do i create a db file in C#? a friend told me it was in the toolbox and not to use sqlite. I dont see anything that could be it, nor what it is called. google didnt help:( ...
Can anyone point me to a good primer on how a large scale commercial website like amazon.com is set up? Most importantly, I'd like to know about how the databases are set up. Do they have a distributed set of databases to balance the load, that all sends updates to one 'master' database, etc.? Doesn't have to be the inside dope(although ...
I'm using a remote 3rd party storage solution that does not have support for transactions. I want to implement my own pseudo-ACIDity in .NET for this solution by simply attempting to rewrite/delete non-failing Entity inserts/update to get to an old-data-but-good-data state when other inserts/updates fail inside a transaction context. I...
To make a long question short, I know about the basics of a Relational Database, Indexing ,Replication, Locking, Concurrency, etc, and SQL syntax (SELECT,INSERT,UPDATE,DELETE, CREATE,DROP,ALTER,TRUNCATE) when used with simple expressions such as: SELECT EventID,EventName FROM Events WHERE CustomerID=5 ORDER BY EventType But I don't un...
A while back I wrote an application which used Spring AOP for defining which methods were transactional. I am now having second thoughts as to how much of a great idea this was; I have been hit a few times after a minor refactor (changing method signatures etc), which of course doesn't become apparent until something actually goes wrong ...
What i would like to do is scan a disc or a drive (usb, main hdd, etc) for files and store its info in a db. Then i would search the db to a particular file to find where it is stored. Alternatively i cans search how old copys are for archiving reasons or if i have dupes of something and dont need to rearchive it or look for a dupe in th...