Re: [sqlite] SQLite on RAM
At 16:19 10/10/2006, you wrote: Hi List, Is it possible to use SQLite on RAM (where there is no file system) i.e. directly on memory, (No Hard disk). I am planning to use it on RAM inside TV. How it will read and write on RAM. Yes is possible to run SQLite on RAM, we do it 24/7 on a device. What OS will you use? What is TV (not a television, i suppouse)? Do you want the data go out on power off? Or you need data remains on next boot? Do you have direct access to hardware and designs or are you hacking it? Depending in your answers, it may be more or less difficult/easy. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] PK and rowid
On Wed, 11 Oct 2006 00:19:28 -0700 (PDT), you wrote: >Hi, > > If I declare my column as, "uniqId integer primary key", > now if I say something like, > select * from tbl1 where uniqId=x; > > Will the uniqId be same as rowid, making my table look ups > faster as I am using row id only. If not whats the way to > assign my uniqId to the row id so that my lookups would be > faster. http://www.sqlite.org/lang_createtable.html by drh> "Specifying a PRIMARY KEY normally just creates a UNIQUE index on the corresponding columns. However, if primary key is on a single column that has datatype INTEGER, then that column is used internally as the actual key of the B-Tree for the table. This means that the column may only hold unique integer values. (Except for this one case, SQLite ignores the datatype specification of columns and allows any kind of data to be put in a column regardless of its declared datatype.) If a table does not have an INTEGER PRIMARY KEY column, then the B-Tree key will be a automatically generated integer. The B-Tree key for a row can always be accessed using one of the special names "ROWID", "OID", or "_ROWID_". This is true regardless of whether or not there is an INTEGER PRIMARY KEY. An INTEGER PRIMARY KEY column can also include the keyword AUTOINCREMENT. The AUTOINCREMENT keyword modified the way that B-Tree keys are automatically generated. Additional detail on automatic B-Tree key generation is available separately." > ... > Chetana. I hope this helps. -- ( Kees Nuyt ) c[_] - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] new sqlite-based webserver
Gunter, I finally managed to get to your server and look at what you have done. It is interesting and ingenious to embed Javascript as an application server language and to integrate it with Sqlite. Your son has something to get his teeth into. I haven't looked closely enough at your code to see if you do this, but I defined callback functions which could be triggered by Sqlite successfully retrieving a row. The result is the ability to dynamically create not only JS arrays but also HTML tables and even PostScript components. I built a header parser with an efficient lexical analyser to drive a state machine that takes care of POST and GET and their variants. My goal is a highly scalable, high throughput application server. That is why I use a byte-code compiled metalanguage rather than interpretive. I am currently looking at ways of making it optimally utilize the multiple processors on our P-Series server. Günter Greschenz wrote: Hi, the reasons why i did this: 1) i wanted to have a simple webserver to get my son involved in programming an online game, and he knows already a little bit javascript 2) my hobby is programming in c++ and javascript, but at work i have to code in c#, so i just wanted to have some fun :-) i think its no a new idea, ive seen some webservers using javascript as backend language, but everything i found was to complicated to install/use or to complicated to port to a new hw-platform (i want to run it on my linksys-nslu2 with ftpd to my topfield hd-vcr to program the recordings via web). and i like sqlite very much and no webserver i found had this combination. if you look at my code, you see that i just use *) sqlite *) the javascript-engine from mozilla (very advanced: js v1.7 including xml support...), *) some glue code to access sqlite and a simple http server from js (only one file: gas.cpp) the trick between js and sqlite is like yours: every sql statement executed returns a 2-dim array... one thing is maybe iteresting: the class "DBItem". its a kind of (very simple) or-mapper. it maps the properties of a javascript-object to the columns of a table. here is a code example: var db = new Database("user.sdb"); db.exec("create table if not exists user (id integer primary key autoincrement, name varchar unique, pwd varchar, test varchar)"); var user = new DBItem(db, "user"); user._name = "Guenter"; user._pwd = "FooBar1234567890"; user._test = "blubb"; user.flush(); var id = user._id; var user = new DBItem(db, "user", id); print("name="+user._name+"\n"); //db.exec("delete from user where id="+id); if you are still curious (or anyone else ?), i can send you the actual source by mail. :-) btw: i had a look into your http-source: looks nice, but its maybe to complicated to implement my features like http-multipart-posts. cu, gg John Stanton schrieb: The multi-threaded application/www server I described requires no threading involvement from the application programmer. That programmer uses SQL, HTML, Javascript and the application language we call MUV. Think about it, when you use Apache you don't have to be aware of its internal threading. The only significant synchronisation element is to do with multiple users of Sqlite, and that is handled transparently to the application programmer. What I was curious about was your statement that you used Javascript as a backend. Do you have a novel idea there? For example my application language will, inter alia, populate Javascript arrays from an SQL statement. Do you have any such features or something more ingenious? (I still cannot get access to your server). My application server runs on Win98, Win2000/XP, Linux, AIX 4.2 and 5.3. The executive, fileserving, compression and CGI components are realised in less than 20K of code. HTML V2 is implemented. There are some old fragments of this program at http://www.viacognis.com/muvm. If you are interested I can dig out the current code and let you have it. Günter Greschenz wrote: Hi, normally i like multithreading, but in this case i like the simple approach (at least for rendering the pages), because as application programmer (the guy who will develop the apps in javascript) its much easier if you dont have to think about locks, racing conditions and other pitfalls. and the rendering itself is (depending on what you do, of course) fast enough for me (simple pages need <10ms !). I want to multithread the upload to the client after all work is done. in my current implementation the complete server is blocked until the download is finished. in my logfiles i have entries with 25 minutes (see "http://greschenz.dyndns.org/logsByTime.html;) !!! thats really unacceptable ! could you mail me some samples howto multithread portable (linux & win32) ? cu, gg John Stanton schrieb: Gunter, I recently wrote a multi-threaded portable web server in simpl ANSI C. It uses
Re: [sqlite] new sqlite-based webserver
This is very very sweet :) Many thanks for sharing Greschenz. I would love to see this project mature. Maybe something like a ThinClient webserver with Javascript as the backend so we could write lovely web apps with AJAX support that offers database like features? Could it also run on Thinstation with some attached storage? Wow! Here's some other ideas: * Make it possible to include external classes or files, for example include('myclass.jsp') * add some build it object to make it easier to do stuff inside the server. Example Mail, File, Scheduler var mail = new Mail() mail.to = '[EMAIL PROTECTED]'; mail.from = '[EMAIL PROTECTED]' mail.subject = 'Hello'; mail.send() var f = new File('contacts.xml'); var xml = f.readAll(); var sch = new Scheduler(); if(!sch.exists('MyImporter')) { sch.setName('MyImporter'); sch.setInterval(30); // every 30 minutes sch.execute('imports.jsp'); sch.save(); } Just my 2 cents. __ Raymond Irving __ Raymond Irving --- Günter Greschenz <[EMAIL PROTECTED]> wrote: > Hi, > > the reasons why i did this: > 1) i wanted to have a simple webserver to get my son > involved in > programming an online game, and he knows already a > little bit javascript > 2) my hobby is programming in c++ and javascript, > but at work i have to > code in c#, so i just wanted to have some fun :-) > > i think its no a new idea, ive seen some webservers > using javascript as > backend language, but everything i found was to > complicated to > install/use or to complicated to port to a new > hw-platform (i want to > run it on my linksys-nslu2 with ftpd to my topfield > hd-vcr to program > the recordings via web). > and i like sqlite very much and no webserver i found > had this combination. > if you look at my code, you see that i just use > *) sqlite > *) the javascript-engine from mozilla (very > advanced: js v1.7 including > xml support...), > *) some glue code to access sqlite and a simple http > server from js > (only one file: gas.cpp) > > the trick between js and sqlite is like yours: every > sql statement > executed returns a 2-dim array... > one thing is maybe iteresting: the class "DBItem". > its a kind of (very > simple) or-mapper. > it maps the properties of a javascript-object to the > columns of a table. > here is a code example: > > var db = new Database("user.sdb"); > db.exec("create table if not exists user (id > integer primary key > autoincrement, name varchar unique, pwd varchar, > test varchar)"); > var user = new DBItem(db, "user"); > user._name = "Guenter"; > user._pwd = "FooBar1234567890"; > user._test = "blubb"; > user.flush(); > var id = user._id; > var user = new DBItem(db, "user", id); > print("name="+user._name+"\n"); > //db.exec("delete from user where id="+id); > > if you are still curious (or anyone else ?), i can > send you the actual > source by mail. :-) > > btw: i had a look into your http-source: looks nice, > but its maybe to > complicated to implement my features like > http-multipart-posts. > > cu, gg > > > > > > John Stanton schrieb: > > The multi-threaded application/www server I > described requires no > > threading involvement from the application > programmer. That > > programmer uses SQL, HTML, Javascript and the > application language we > > call MUV. Think about it, when you use Apache you > don't have to be > > aware of its internal threading. > > > > The only significant synchronisation element is to > do with multiple > > users of Sqlite, and that is handled transparently > to the application > > programmer. > > > > What I was curious about was your statement that > you used Javascript > > as a backend. Do you have a novel idea there? > For example my > > application language will, inter alia, populate > Javascript arrays from > > an SQL statement. Do you have any such features > or something more > > ingenious? (I still cannot get access to your > server). > > > > My application server runs on Win98, Win2000/XP, > Linux, AIX 4.2 and > > 5.3. The executive, fileserving, compression and > CGI components are > > realised in less than 20K of code. HTML V2 is > implemented. > > > > There are some old fragments of this program at > > http://www.viacognis.com/muvm. If you are > interested I can dig out > > the current code and let you have it. > > > > > > Günter Greschenz wrote: > >> Hi, > >> > >> normally i like multithreading, but in this case > i like the simple > >> approach (at least for rendering the pages), > because as application > >> programmer (the guy who will develop the apps in > javascript) its much > >> easier if you dont have to think about locks, > racing conditions and > >> other pitfalls. and the rendering itself is > (depending on what you > >> do, of course) fast enough for me (simple pages > need <10ms !). I want > >> to multithread the upload to the client after all > work is done. > >> in my current implementation the
Re: Re: [sqlite] wxSqlite- Long Insertion time
On 10/10/06, Lloyd <[EMAIL PROTECTED]> wrote: For me consistancy, atomicity...(ACID) are not a problem. But the speed of operation is major constraint. How can I achieve speed in insertion cases like this? Are you doing these insertions in a transaction? - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] new sqlite-based webserver
Hi, the reasons why i did this: 1) i wanted to have a simple webserver to get my son involved in programming an online game, and he knows already a little bit javascript 2) my hobby is programming in c++ and javascript, but at work i have to code in c#, so i just wanted to have some fun :-) i think its no a new idea, ive seen some webservers using javascript as backend language, but everything i found was to complicated to install/use or to complicated to port to a new hw-platform (i want to run it on my linksys-nslu2 with ftpd to my topfield hd-vcr to program the recordings via web). and i like sqlite very much and no webserver i found had this combination. if you look at my code, you see that i just use *) sqlite *) the javascript-engine from mozilla (very advanced: js v1.7 including xml support...), *) some glue code to access sqlite and a simple http server from js (only one file: gas.cpp) the trick between js and sqlite is like yours: every sql statement executed returns a 2-dim array... one thing is maybe iteresting: the class "DBItem". its a kind of (very simple) or-mapper. it maps the properties of a javascript-object to the columns of a table. here is a code example: var db = new Database("user.sdb"); db.exec("create table if not exists user (id integer primary key autoincrement, name varchar unique, pwd varchar, test varchar)"); var user = new DBItem(db, "user"); user._name = "Guenter"; user._pwd = "FooBar1234567890"; user._test = "blubb"; user.flush(); var id = user._id; var user = new DBItem(db, "user", id); print("name="+user._name+"\n"); //db.exec("delete from user where id="+id); if you are still curious (or anyone else ?), i can send you the actual source by mail. :-) btw: i had a look into your http-source: looks nice, but its maybe to complicated to implement my features like http-multipart-posts. cu, gg John Stanton schrieb: The multi-threaded application/www server I described requires no threading involvement from the application programmer. That programmer uses SQL, HTML, Javascript and the application language we call MUV. Think about it, when you use Apache you don't have to be aware of its internal threading. The only significant synchronisation element is to do with multiple users of Sqlite, and that is handled transparently to the application programmer. What I was curious about was your statement that you used Javascript as a backend. Do you have a novel idea there? For example my application language will, inter alia, populate Javascript arrays from an SQL statement. Do you have any such features or something more ingenious? (I still cannot get access to your server). My application server runs on Win98, Win2000/XP, Linux, AIX 4.2 and 5.3. The executive, fileserving, compression and CGI components are realised in less than 20K of code. HTML V2 is implemented. There are some old fragments of this program at http://www.viacognis.com/muvm. If you are interested I can dig out the current code and let you have it. Günter Greschenz wrote: Hi, normally i like multithreading, but in this case i like the simple approach (at least for rendering the pages), because as application programmer (the guy who will develop the apps in javascript) its much easier if you dont have to think about locks, racing conditions and other pitfalls. and the rendering itself is (depending on what you do, of course) fast enough for me (simple pages need <10ms !). I want to multithread the upload to the client after all work is done. in my current implementation the complete server is blocked until the download is finished. in my logfiles i have entries with 25 minutes (see "http://greschenz.dyndns.org/logsByTime.html;) !!! thats really unacceptable ! could you mail me some samples howto multithread portable (linux & win32) ? cu, gg John Stanton schrieb: Gunter, I recently wrote a multi-threaded portable web server in simpl ANSI C. It uses Win32 threads or pthreads. It caches threads and re-uses them on a most recently used basis. Efficiency is obtained by using TransmitFile (Win32) or sendfile (Unix). The logic is simple for an efficient, multi-threaded www server. An added bonus of mutli-threading is that it takes advantage of the ability of a browser to open multiple concurrent connections and persistent connections. My WWW server is set up as an application server, with embedded Sqlite and an embedded byte-coded metalanguage used to define DHTML pages. An associated compiler produces the byte code. By using compiled byte code the overhead of interpreting a script-type language is avoided. Günter Greschenz wrote: Hi, yes i know, the problem is, its single-threaded (because of protability), so if anyone starts a download with a slow connection, the server is blocked for other connections.. im still thinking about this problem... single-threading whle rendering th
[sqlite] Journal file and EFS space
Hi, We are using embedded flash file system, now we have catch22 situation. When the EFS is full (we seeing this when we have <13k on EFS, ofcourse out of that 13k some will go for system) , the users aren't able to delete any content from the EFS. sqllite3_step() is returning error. We suspect that its not able to create the journal needed for the transaction. Tried using different approaches, like enclosing that in a begin/end transaction and so, but nothing did work out, so we are assuming that may be the reason. Wanted to know, like whats the optimal amount of EFS usually that we have to reserve so atleast the user can delete one object from the table so that he can make further deletes. ... Chetana.
Re: [sqlite] new sqlite-based webserver
The multi-threaded application/www server I described requires no threading involvement from the application programmer. That programmer uses SQL, HTML, Javascript and the application language we call MUV. Think about it, when you use Apache you don't have to be aware of its internal threading. The only significant synchronisation element is to do with multiple users of Sqlite, and that is handled transparently to the application programmer. What I was curious about was your statement that you used Javascript as a backend. Do you have a novel idea there? For example my application language will, inter alia, populate Javascript arrays from an SQL statement. Do you have any such features or something more ingenious? (I still cannot get access to your server). My application server runs on Win98, Win2000/XP, Linux, AIX 4.2 and 5.3. The executive, fileserving, compression and CGI components are realised in less than 20K of code. HTML V2 is implemented. There are some old fragments of this program at http://www.viacognis.com/muvm. If you are interested I can dig out the current code and let you have it. Günter Greschenz wrote: Hi, normally i like multithreading, but in this case i like the simple approach (at least for rendering the pages), because as application programmer (the guy who will develop the apps in javascript) its much easier if you dont have to think about locks, racing conditions and other pitfalls. and the rendering itself is (depending on what you do, of course) fast enough for me (simple pages need <10ms !). I want to multithread the upload to the client after all work is done. in my current implementation the complete server is blocked until the download is finished. in my logfiles i have entries with 25 minutes (see "http://greschenz.dyndns.org/logsByTime.html;) !!! thats really unacceptable ! could you mail me some samples howto multithread portable (linux & win32) ? cu, gg John Stanton schrieb: Gunter, I recently wrote a multi-threaded portable web server in simpl ANSI C. It uses Win32 threads or pthreads. It caches threads and re-uses them on a most recently used basis. Efficiency is obtained by using TransmitFile (Win32) or sendfile (Unix). The logic is simple for an efficient, multi-threaded www server. An added bonus of mutli-threading is that it takes advantage of the ability of a browser to open multiple concurrent connections and persistent connections. My WWW server is set up as an application server, with embedded Sqlite and an embedded byte-coded metalanguage used to define DHTML pages. An associated compiler produces the byte code. By using compiled byte code the overhead of interpreting a script-type language is avoided. Günter Greschenz wrote: Hi, yes i know, the problem is, its single-threaded (because of protability), so if anyone starts a download with a slow connection, the server is blocked for other connections.. im still thinking about this problem... single-threading whle rendering th pages and multithreading for sending them to the clients, or maybe async socket writes (is this possible in linux ?) but i've seen (in the logs :-) a lot of people are interested. its funny to sit at the console at home and see the log messages when anyone comes by... at the moment its just an alpha-version... but if i have more time (or maybe anyone helps me) it will improve ! the server itself is an i386-linux at ~ 300mhz, so dont expect too much ... Fred Williams schrieb: What'ch got it running on, a 286? Tried three different times and got tired waiting all three times :-( Not going to stir much interest with response times like that! -Original Message- From: Günter Greschenz [mailto:[EMAIL PROTECTED] Sent: Monday, October 09, 2006 12:04 PM To: sqlite-users@sqlite.org Subject: [sqlite] new sqlite-based webserver hi, i dont know if anyone is interested in my new open source project... i implemented a little webserver with javascript as backend-language (1.7 from mozilla 2.0.rc1) and sqlite as datastorage (3.3.7) the server is serving himself on "http://greschenz.dyndns.org; :-) the source can be downloaded at "http://greschenz.dyndns.org/download/gas/; its compilable with gcc(linux) and vs2005(win32) please send me any comments / ideas... cu, gg -- --- To unsubscribe, send email to [EMAIL PROTECTED] -- --- - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED]
Re: [sqlite] new sqlite-based webserver
hi, its asymetric, its (seen from my home) 2mbit downstream and (i'm not sure) 384kbit upstream (but in any case less than 1mbit). the other direction wout be better for serving (now its better for surfing :-) but for my own purpose it is enough :-) at the end of the year 16mbit could be available in my region, so the upstream is 8 times greater then... and its not to expensive... cu, gg Griggs, Donald schrieb: Greetings, Günter, Regarding: "...my server is running at home ... and has a dsl-(2mbit) connection to the world." Do you know if your connection is symmetric? In the U.S. most all home DSL circuits are ADSL, with the upload maximum speed just a fraction of the download maximum. Places like http://dslreports.com/tools will let you run some speed tests -- though I imagine a European test site would be a better choice for you. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] new sqlite-based webserver
Greetings, Günter, Regarding: "...my server is running at home ... and has a dsl-(2mbit) connection to the world." Do you know if your connection is symmetric? In the U.S. most all home DSL circuits are ADSL, with the upload maximum speed just a fraction of the download maximum. Places like http://dslreports.com/tools will let you run some speed tests -- though I imagine a European test site would be a better choice for you. - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] are there known software patents concerning sqlite?
Hello list, as software patents become a more and more important issue ( one could also call it a pain in the *ss) I would like to know if anyone has done a patent research for sqlite. Or does anyone know about people who claimed that sqlite would violate therir patens? kind regards, gunnar - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] new sqlite-based webserver
Hi, normally i like multithreading, but in this case i like the simple approach (at least for rendering the pages), because as application programmer (the guy who will develop the apps in javascript) its much easier if you dont have to think about locks, racing conditions and other pitfalls. and the rendering itself is (depending on what you do, of course) fast enough for me (simple pages need <10ms !). I want to multithread the upload to the client after all work is done. in my current implementation the complete server is blocked until the download is finished. in my logfiles i have entries with 25 minutes (see "http://greschenz.dyndns.org/logsByTime.html;) !!! thats really unacceptable ! could you mail me some samples howto multithread portable (linux & win32) ? cu, gg John Stanton schrieb: Gunter, I recently wrote a multi-threaded portable web server in simpl ANSI C. It uses Win32 threads or pthreads. It caches threads and re-uses them on a most recently used basis. Efficiency is obtained by using TransmitFile (Win32) or sendfile (Unix). The logic is simple for an efficient, multi-threaded www server. An added bonus of mutli-threading is that it takes advantage of the ability of a browser to open multiple concurrent connections and persistent connections. My WWW server is set up as an application server, with embedded Sqlite and an embedded byte-coded metalanguage used to define DHTML pages. An associated compiler produces the byte code. By using compiled byte code the overhead of interpreting a script-type language is avoided. Günter Greschenz wrote: Hi, yes i know, the problem is, its single-threaded (because of protability), so if anyone starts a download with a slow connection, the server is blocked for other connections.. im still thinking about this problem... single-threading whle rendering th pages and multithreading for sending them to the clients, or maybe async socket writes (is this possible in linux ?) but i've seen (in the logs :-) a lot of people are interested. its funny to sit at the console at home and see the log messages when anyone comes by... at the moment its just an alpha-version... but if i have more time (or maybe anyone helps me) it will improve ! the server itself is an i386-linux at ~ 300mhz, so dont expect too much ... Fred Williams schrieb: What'ch got it running on, a 286? Tried three different times and got tired waiting all three times :-( Not going to stir much interest with response times like that! -Original Message- From: Günter Greschenz [mailto:[EMAIL PROTECTED] Sent: Monday, October 09, 2006 12:04 PM To: sqlite-users@sqlite.org Subject: [sqlite] new sqlite-based webserver hi, i dont know if anyone is interested in my new open source project... i implemented a little webserver with javascript as backend-language (1.7 from mozilla 2.0.rc1) and sqlite as datastorage (3.3.7) the server is serving himself on "http://greschenz.dyndns.org; :-) the source can be downloaded at "http://greschenz.dyndns.org/download/gas/; its compilable with gcc(linux) and vs2005(win32) please send me any comments / ideas... cu, gg -- --- To unsubscribe, send email to [EMAIL PROTECTED] -- --- - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] new sqlite-based webserver
Hi, my server is running at home (300mhz(?), linux (suse 9.3) and has a dsl-(2mbit) connection to the world. running inernally (my laptop connected directly via wlan) its really fast (look at the logfile: http://greschenz.dyndns.org/logsByPath.html), it could be a internal routing problem with my router (i've 2 switches between server and dsl-router...) if drh allows it, i could add the source/bin packages for download at "http://sqlite.org/contrib;, i think this would be a place where everyone has access :-) cu, gg Dennis Cote schrieb: John Stanton wrote: Martin Jenkins wrote: John Stanton wrote: Martin Jenkins wrote: Seems ok now. Quite fast even. It is still dead. Address 62.194.135.186 doesn't respond. Traceroute fails. Odd. It's still working here (UK). DNSStuff reports a different address though (62.104.138.84) and a traceroute from there is fine (13 hops). I get the same address from my local box but traceroute times out after linx2.mcbone.net. Martin - To unsubscribe, send email to [EMAIL PROTECTED] - No joy from here (US Midwest). Traceroute times out on mcbone.net. Ping fails. - To unsubscribe, send email to [EMAIL PROTECTED] - It works from here (western Canada) at 10:45 MDT. I also see this name resolved to IP address 62.104.138.84. It's a little slow, taking about 10 seconds to load, but not too bad. Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
AW: [sqlite] PK and rowid
uniqId is the same as rowid, so you will get the same execution plans for ...where rowid=x and ... where uniqId=x. - Ursprüngliche Mail Von: chetana bhargav <[EMAIL PROTECTED]> An: sqlite-users@sqlite.org Gesendet: Mittwoch, den 11. Oktober 2006, 09:19:28 Uhr Betreff: [sqlite] PK and rowid Hi, If I declare my column as, "uniqId integer primary key", now if I say something like, select * from tbl1 where uniqId=x; Will the uniqId be same as rowid, making my table look ups faster as I am using row id only. If not whats the way to assign my uniqId to the row id so that my lookups would be faster. ... Chetana. - Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail. ___ Der frühe Vogel fängt den Wurm. Hier gelangen Sie zum neuen Yahoo! Mail: http://mail.yahoo.de
[sqlite] PK and rowid
Hi, If I declare my column as, "uniqId integer primary key", now if I say something like, select * from tbl1 where uniqId=x; Will the uniqId be same as rowid, making my table look ups faster as I am using row id only. If not whats the way to assign my uniqId to the row id so that my lookups would be faster. ... Chetana. - Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail.