database

How to tell selenium to use test database?

I'm using selenium-client to run a few tests, but Selenium seems to be using my development database. How can I point it to use my test DB? ...

How do you read an image from the Categories table in the Northwind database?

In SQL Server 2005, how do you read an image from the Categories table in Northwind? I can upload my image to my own database and display it from there, but I can't display an image from Categories table in Northwind. Can someone please show me how to do this? ...

Should I use "id" or "unique username"?

I am using PHP, AS3 and mysql. I have a website. A flash(as3) website. The flash website store the members' information in mysql database through php. In "members" table, i have "id" as the primary key and "username" as a unique field. Now my situation is: When flash want to display a member's profile. My questions: Should Flash pas...

Programming against an ACT! database

Does anyone know the database format for ACT. I am trying to write an exporter for ACT! I've looked for libraries and can't find any obvious ones that will help me interact with the CRM system. ...

export data from oracle 10g and import to oracle 9i

HI all Can you tell how to import data from oracle 10g to Oracle 9i. Is it ok i can export the data from Oracle 10g and import it to 9i directly, it should work??? or i need to follow some other procedure??? Kindly help me Thanks in advance Joseph ...

What is best tool to compare two SQL Server databases (schema and data)?

I would like to compare two SQL Server databases including schema (table structure) and data in tables too. What is best tool to do this? ...

iphone sdk sqlite lookup performance for +40k records

hey guys i wanted to know the best way to get this thing done: i have a huge table with +40k records (tv show titles) in sqlite and i want to do real time lookups to this table. for eg if user searches for a show, as and when user enters search terms i read sqlite and filter records after every keystroke (like google search suggestion) ...

Relevant Search Results Across Multiple Databases

I have three databases that all have the contents of several web pages in them. What would be the best way to go about searching all three and having the most relevant web page at the top of the search results? The only way I can think of is break down content by word count and/or creating a complex set of search rules to give one cont...

Best optimizing a large DB for primary key queries

Suppose you have a very large database, and to simplify lets say it consists of one major table you will be doing your lookups on with one (and only one) primary key field - pk. Given the fact that all lookups are going to be basically SELECT * FROM table_name WHERE pk=someKeyValue, what is the best way to optimize this database for the...

Help figuring out approaches to (near) real time multi dimensional data querying

I have a system that involves numerous related tables. Think of a standard category/product/order/customer/orderitem scenario. Some tables are self referencing (like Categories). None of the tables are particularly large (around 100k rows with an estimated scale to around 1 million rows). There are a lot of dimensions to this data I ...

Hibernate and special chars

Hi, Imagine I have a database with one table, this table has only one field named "word" and some other data, imagine also that user can search data by typing contents of this field. I have a lot of words on this table with Spanish accents. Word examples ácido autobús camión Question If user searches for "acido" or "ácido" words t...

Does selecting only indexed attributes result in faster queries?

When performing a query where the attributes selected make up the components of an index does that result in a faster query? I would imagine that the query planner/optimizer could see that the requested columns could be satisfied completely by the index scan. Trivial Example CREATE TABLE "liked" ( "id" BIGINT NOT NULL DEFAULT nextva...

PreparedStatements and performance

So I keep hearing that PreparedStatements are good for performance. We have a Java application in which we use the regular 'Statement' more than we use the 'PreparedStatement'. While trying to move towards using more PreparedStatements, I am trying to get a more thorough understanding of how PreparedStatements work - on the client side ...

Which ORM is the best when using Stored Procedures

So, I asked before what a good ORM was and the answer seemed to be nhibernate. I went through the giant learning curve and well it’s awesome, but totally won’t work for me. I sadly must use stored procedures and its ability to use them is very limited. So I have Business objects (DEVELOPERS WRITE) and some SPROCS (DBA WRITE)…… I know wh...

What are some best practises and "rules of thumb" for creating database indexes?

I have an app, which cycles through a huge number of records in a database table and performs a number of SQL and .Net operations on records within that database (currently I am using Castle.ActiveRecord on PostgreSQL). I added some basic btree indexes on a couple of the feilds, and as you would expect, the peformance of the SQL operati...

Database efficiency

I am about to write a program to keep track of my school assignments and I was wondering what database language would be the most efficient and simple to implement to track the meta-data of the assignments? I am thinking about XML, but it would require several documents. I (currently) have at least ten assignments per week for 45 weeks....

Access Compare Database Schema

Hello I want to compare two Access database and check is there any field or type mismatch within that or not. Is there any way we can check that using dataset or is there a faster way to do that? Thanks. ...

Is it possible to connect to a server DB from Windows Mobile App

Is there any way that I can connect to a server DB (Oracle, MS SQL, Sybase, ...) from a Windows Mobile application (written in C# using VS 2008). Is there support for say ODBC or another technologie? I'm connecting to a LAN via WLAN or via UMTS. There is no possibility for me to install an additional server component. ...

Database bandwidth much higher compared to server bandwidth. Normal?

A while back we were transferring our reasonably popular forum to a new dedicated server (with the same host), and we noticed something weird. At first we used the new server to host just the database as this was the biggest issue. Then later we transferred the forum files and changed the dns for the domain. When we look back at the ban...

Make a application retrieve data from MySQL database.

I'm looking to make a application that shows something from a MySQL data base. They should go in Order according to which ever one is next. The user would set a time that the events should happen, along with a Name for it. Then, that information would go intoa a MySQL database and it will be shown along with the other events in the appli...