In my application ,am work with a large database.Nearly 75000 records present in a table(totally 6 tables are there).i want to get a data from three different table at a time.i completed that.but the search process was slow.how can i optimise the searching process? ...
Hi , What's better way to format following sql statement considering both readability and performance. Thanks. sql = (char *)" SELECT * ,rowid FROM tblEvent_basic " " WHERE " " service_id = ? AND " " (" " (start_time >= ? AND start_time <= ?) OR " ...
I have a view with a UILabel and a UITableView. I'm using this code to get a string from a database: -(void)getOneQuestion:(int)flashcardId categoryID:(int)categoryId { flashCardText=[[NSString alloc] init]; flashCardAnswer=[[NSString alloc] init]; NSString *martialStr=[NSString stringWithFormat:@"%d", flashcardId]; ...
I'm trying to pull and format timestamp from my SQLite db. In my reading, it seems that SQLite formatting is extremely limited compared to date formatting conversion available to PHP. I have this query coming from javascript: SELECT strftime('%m %d, %Y', timestamp) AS saveddate And it returns: 03 03, 2009 I'm trying to get it to re...
For my first Django app, I'm trying to write a simple quote collection site (think bash.org), with really simple functionality, just to get my feet wet. I'm using sqlite as my database, since it's the easiest to setup. Here's my only model right now: class Quote(models.Model): text = models.TextField(); upvotes = models.Intege...
I'm working with Datamapper which allows you to specify either a path to a database file on your system or simply the string "memory" and then an "in-memory" database is used. However, I have no idea what this means. Is an "in-memory" database purely memory-based or does it get serialized to the filesystem at some point? What's the b...
Hey guys, here is the low down. I have one table, consisting of a primary key(col1), text(col2), and text(col3). Basically a map. This table contains about 200k rows. It basically takes me about 1.x seconds to retrieve a single row (this is all I want). I'm basically using select * from table where col2 = 'some value'. I've tried creat...
I am using Persistent Storage in Blackberry,now i want to use SQlite Database with Blackberry 4.5.But i didn't get any tutorial for that.Can i use SQlite with Blackberry 4.5 or i need any other version of Blackberry. ...
i am getting error for statement TInt err1 =stmt.Prepare(db,_L("INSERT INTO MyContacts(ServerContactID,UserName,FirstName,LastName,Country,IsBlocked,RequestStatus,MarkForDeletion) VALUES(:ServerContactID,:UserName,:FirstName,:LastName,:Country,:IsBlocked,:RequestStatus,:MarkForDeletion)")); for this statements if i print err1 i am g...
I'm new to SQLite and Java, and I'm trying to learn things on the fly. I have a column that has some numeric values in it, and I would like to get the sum of it and display it in a textview. My current code is this: public Cursor getTotal() { return sqliteDatabase2.rawQuery( "SELECT SUM(COL_VALUES) as sum FROM myTable", nul...
I have an events based table that I would like to produce a query, by minute for the number of events that were occuring. For example, I have an event table like: CREATE TABLE events ( session_id TEXT, event TEXT, time_stamp DATETIME ) Which I have transformed into the following type of table: CREATE TABLE ses...
How to write prepared statements for SQLite in iPhone? Is it possible to do SQL Injection in iPhone apps that use sqlite db? ...
my application shows this error asm CPSqliteConnectionStatementForSQL 0x30897lb3:10 and it stopped at this breakpoint in debugger 0x308971cb <+0024> mov 0x8(%edi),%eax does someone know about it? ...
I'm trying to use SubSonic 3.0 with SQLite 3 in ASP.NET MVC. After initial pains of setting it up I am finally able to retrieve data from my single (so far) table database, however I never get a value for the Testimonial column. I tried renaming it to something like TestimonialText, I tried changing its data type to VARCHAR, NVARCHAR wit...
I am currently writing an IRC client and I've been trying to figure out a good way to store the server settings. Basically a big list of networks and their servers as most IRC clients have. I had decided on using SQLite but then I wanted to make the list freely available online in XML format (and perhaps definitive), for other IRC apps ...
Do I have to parse the SQL-script manually and execute each statement separately or are there better ways? Iam looking for a programmatically solution, I know there are tools which are already able to do this. It would be good if the solution would work for all database systems, not just sqlite. ...
I have a database that contains decimals. The column is set up as ".. decimal(5,2) not null. What I'm trying to do is to find the sum of the column and displaying it in a text field by using this code.. public int getTotal() { Cursor cursor = sqliteDatabase2.rawQuery( "SELECT SUM(thedata) FROM thetable", null); if(cursor...
I want to record number of hits to the pages and I'm thinking either plain file-based or SQLite storage. File-based option A file includes only an integer incremented with each page visit and every page has a unique file name. If I open a file using a mode, I can write but is it possible to not to close it in order to save from opening ...
Im currently developing a system where the user will end up having large arrays( using android). However the JVM memory is at risk of running out, so in order to prevent this I was thinking of creating a temporary database and store the data in there. However, one of the concerns that comes to me is the SDcard limited by read and write....
I am wanting to drop a column from a table in my SQLite database, and it seems there is no support for dropping columns with ALTER TABLE. Currently, I am using CREATE TABLE AS to create a new temporary table (minus the column I don't want) from one of my existing tables. I planned on dropping the original table and renaming the temporary...