I have a table with about 3000 records that I query often. Does mysql provide some sort of View that can load the table in memory and stay synced with my table (similar to a cache), so i can query this view and have really fast results? ...
I cant see my table is using Index...EXPLAIN given me this id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE table1 const web web 258 const 1 1 SIMPLE table2 const web web 258 const 1 1 SIMPLE table3 const web web ...
I'm using maven war plugin to build war package. Before package is build test are executed. To preinitialize my database with sample data I use spring bean. I would like to have different data in my db for tests and different when application starts. I was thinking that maybe it is possible to use two different spring initializer class...
I have a function call in a query, and that result has to be returned with two names. Example: SELECT myFunction(column1) as Name1, column2 as Name2 FROM myTable I want the result of myFunction to be returned in two different columns. Is this possible without making another function call in the column list? ...
Hey all, I'm looking for a database that I can distribute with a web application, that will store user preferences for various widgets. A good example is the kind of database design that apple uses to store information about its widgets. So the weather widget stores location, while the notes widget stores notes. I think I'm looking f...
This might sound dumb but yeah i need a effective way of doing this. Am using php at the moment and man it is slow. Any pointers please. Cheers. ...
Hey all I'm having a go at developing my first android application and have never really used databases before. Anyways I need to populate and update a database based on XML files retrieved from the web on a regular basis (say once a day). Just thinking about it iv already run into some problems...Basically I need to display informati...
Hello folks. I need a way to determine the type of a database column (varchar/numeric/date/...) when reading from the DB with PDO. When fetching values from the DB, PDO produces only string values, regardless of the actual type of the table column. Is there any non driver specific way to get this information? I know that there are SQL...
Hi, I need to work on multiple database, and below is my current code. Following code seems to be very very slow and having issues with multiple connection while I view the mysql connection list. So can anyone let me what's wrong with the code and help me to correct the issues and faster performance. $dbHost="localhost"; $dbUser="use...
Here is my code for my db class: package one.two; import java.util.List; import android.app.ListActivity; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; import android.database.sqlite.SQLiteDatabase.CursorFactory; import j...
Hi, has anyone experience with import and export of large collections (from a database in this case) with .net. Using the database export itself is not possible because there are multiple database backends supported and i need this for a kind of platform independent export/import. The problem here is that the XmlSerializer or DataCont...
Hi, I would like your advice regarding Data Base design, I am new to it :-). I have 4 different data elements (tables A,B,C,D) example: A - Contents B - Categories C - Authors and D - Images Every record in tables A,B,C could have associated 1 or more different Images in Table D, BUT for every image in D must be uniquely associated only...
Hi, I'm using SQL Server 2008 R2 and I can't seem to be able to use the geography column type it's meant to have. It doesn't show up in the data type column when I create a new column and when I run this code: CREATE TABLE [Core].[Address2]( [Geo_Id] [geography] NULL); I get Column, parameter, or variable #2: Cannot find data type...
Is it possible to add a new database connection to Django on the fly? I have an application that uses multiple databases (django 1.2.1), and while running, it's allowed to create new databases. I'd need to use this new database right away (django.db.connections[db_alias]). Is it possible without server restart? Using module reload here ...
A month ago I adjusted my database schema. I added a column called ordinal. I rebuilt my model and uploaded my changes. Everything works fine apart from my instance of sfLucene will not rebuild. I run symfony lucene-rebuild frontend But I get the error once it gets to the Model in question (others are fine): propel exception: unk...
What kind of error occurs? What do users experience? Can you access the database using tools and what if you get it back under the 4GB / 10GB limit? ...
I am developing a java project where I do have to fill database from http://projects.zoho.com. Zoho provides API for fatching data. I have developed java transformers for fatching data and using hibernate I feel database. This process, I do, running Main method from transformer. I want there a session to help filling database automatic...
i have a number of tables with a column called OrderId. I have just done a refactoring and i want to get rid of the Order table and i have a new table called Transaction. I want all tables that have an OrderId column to now have a TransactionId column This is complete. I now need to populate the transactionId column. I have a mappi...
Hi there, I'm developing an application that would need to persist data locally in Android devices. I'm aware that Android provides two packages for database persistence, the normal "java.sql" and the "android.database.sqlite"? Which one is used more for persistence? I suppose that "android.database.sqlite" is the implementation of "jav...
I'm having problems using Hibernate and SQL Server 2008. When I try to save an object to database Hibernate throws this: could not retrieve snapshot: com.my.MyClass Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name `'emanagement.patient_visit'.` The user has select, insert,update privileges in database. ...