My friend.. very simple... use a transaction to do that...
BEGIN;
insert into ...
insert into ...
insert into ...
insert into ...
...
...
...
insert into ...
COMMIT;
I usually insert 1 in 5 seconds in a non good PC
--
Cesar Rodas
http://www.phpclasses.org/grank
ommend checking out just the module. If there's
a core API change, the module will follow that change and get
out-of-sync with whatever tarball you're using.
This code is certainly a week or two from being ready to enter a tarball.
-scott
On 10/12/06, Cesar David Rodas Maldonado <[EMAIL
That's very cool... What i am wondering is if is there any way to
download the complete tarball of that folder...
thanks.
On 10/13/06, Scott Hess <[EMAIL PROTECTED]> wrote:
I've checked a new version of the full-text search module into
ext/fts2 under CVS. fts2 uses a very different style of
Thanks Nuyt.
I will implement.
On 10/12/06, Kees Nuyt <[EMAIL PROTECTED]> wrote:
On Thu, 12 Oct 2006 15:24:22 -0400, you wrote:
> PD: I think it could be implement in SQLite to but
> I dont know if it support UNION in selects...
It does. http://www.sqlite.org/lang_select.html
--
( Kees
Hello,
I just would like to let you know about this page that I think it is of your
interest.
Class: guaranix Rank
http://cesars.users.phpclasses.org/grank
Regards
Cesar Rodas
PD: I think it could be implement in SQLite to but I dont know if it support
UNION in selects...
ogle's pagerank and search
engines so impressive, it's the searching and categorization capabilities.
Clay
Cesar David Rodas Maldonado said:
> Some one what to help?
>
> On 9/26/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
>>
>> I am developing a hobby that i
Some one what to help?
On 9/26/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
I am developing a hobby that is how to calculate something like the
PageRank with SQLite for HDD Storage.
Thanks to all.
I am developing a hobby that is how to calculate something like the PageRank
with SQLite for HDD Storage.
Thanks to all.
plenty more. Knuth explains various
type of B-Tree and plenty of merging algorithms.
Cesar David Rodas Maldonado wrote:
> I meen, If SQLite has two index and very large Index (about 10.000.000each
> one) how do i merge it, I mean (index1 = index2 for every one and limit
it
> in thousand).
Thanks for your answer Ms. Smith!
On 9/19/06, Christian Smith <[EMAIL PROTECTED]> wrote:
Cesar David Rodas Maldonado uttered:
> I meen, If SQLite has two index and very large Index (about 10.000.000each
> one) how do i merge it, I mean (index1 = index2 for every one and limit
it
&
I meen, If SQLite has two index and very large Index (about 10.000.000 each
one) how do i merge it, I mean (index1 = index2 for every one and limit it
in thousand).
Understand?
On 9/15/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
Cesar David Rodas Maldonado wrote:
> If there a docume
If there a document of how SQLite Virtual Machine Works ( papers )? I would
like do something similar with B-Tree, B+ Tree but i dont know how to merge
a select with tow Index? Understand my question??
Please answer me
Good afternoon to all!
Please some one can tell me how to optimize SQLite for an inverted index of
about 100.000.000.000 of rows or please how can I do that with B-Trees or
ISAM. Please help me if you can.. Thanks...
I am doing an GNU search project for my University.
What i meaning how sqlite do for search b-tree indexs? the index are copy to
main memory or the merge is done just in hard disk search for every item?
understand my question?
On 9/4/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
Hello to all!
I am developing a appli
Hello to all!
I am developing a application for great performance and I want to know how
SQLite works for merger two list of index, because as i understand every
index is a b-tree right?
Please help me because i need great perfomance, i am developing a very large
Inverted Index.
Thanks to all
I am sorry my friend... try with Dev-cpp! That's better that MS VC. What i
do always is download the source and compile like part of my project or
create the library. I think the first one will better for velocity but not
for update.
On 8/25/06, Rob Richardson <[EMAIL PROTECTED]> wrote:
Thanks Jay now i can understand.
On 8/24/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
> So is the a manual of how can I use the SQLite Btree algorithm for my
own?
It's not exposed so you can do it easily.
> And if I use the Btree will be faster than use SQLite? because SQLite
need
> to
/24/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
I will like to join to your group! what i have to do? how can we exchange
info?
Thanks Pierre Aubert
On 8/24/06, Pierre Aubert < [EMAIL PROTECTED]> wrote:
>
> Hello Cesar,
> I have a lot of idea for ft3 but no
Hello to everyone.
I want to ask something for the people who made SQLite.
Every Index in a table is a Btree?
So is the a manual of how can I use the SQLite Btree algorithm for my own?
And if I use the Btree will be faster than use SQLite? because SQLite need
to understand the SQL and I think
The query SQL query that I sent represents the next search : word1 word2
"word3 word4"
On 8/22/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
I have the next table with about 10.000.000 of records-
CREATE TABLE ft_index (
docid int(11) NOT NULL default '0',
I have the next table with about 10.000.000 of records-
CREATE TABLE ft_index (
docid int(11) NOT NULL default '0',
wordid int(11) NOT NULL default '0',
posicion int(11) NOT NULL default '0',
ranking float NOT NULL default '0',
lang int(11) NOT NULL default '0',
KEY docid
I always include the source into my C program (with KDevelop for linux or
DEV-CPP for windows). And if you do that you could config better.
On 8/14/06, Michael Alperovitch <[EMAIL PROTECTED]> wrote:
Hi,
I am new SQLite user.
How I can link the simple C Program with Sqlite static or shared
Yeah John I am studying Math and computer science (but i am in the first
year, and this is very boring) in National University Of Paraguay.
When I finish my idea i will share my code.
Thanks For understand my English John!
On 8/5/06, John Stanton <[EMAIL PROTECTED]> wrote:
Cesar David
Postgresql, cause this is client-server, I like SQLite,
and with my "insert delay" SQLite for me is more useful than postgresql
On 8/5/06, Clay Dowling <[EMAIL PROTECTED]> wrote:
Cesar David Rodas Maldonado wrote:
> I was thinking a lot in the next month in how can I do the delay i
I was thinking a lot in the next month in how can I do the delay insert and
I found something for do that, is basic because I don't have a lot of
knowledge, I'm just start the University.
OK, I need with SQLite to select all the time as possible, and delay the
Insert, I don't care the time
Try with the ODBC or use PHP (PHP is better than ASP and multi OS)
On 8/1/06, Artie Pagan <[EMAIL PROTECTED]> wrote:
Does anyone know what the connection string is for SQLite using ASP
classic?
Cool!
I will try that!
Thanks Igor!
On 7/31/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
Cesar David Rodas Maldonado
<[EMAIL PROTECTED]> wrote:
> How can I optimize this query
>
> select * from table where col1 = 5 && col2 = 15;
>
> If I know that col2
Hello to all!
How can I optimize this query
select * from table where col1 = 5 && col2 = 15;
If I know that col2 I have 15 rows and col1 I have just 100 rows, I
know that because I save that data in another table.
How can I do for search first where is minus number of result?
The two
I found to give a preference to select and a delay to insert.
:D
On 7/27/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
If a SQLite Db is LOCKED can i exec an TRIGER?
If a SQLite Db is LOCKED can i exec an TRIGER?
Now i have another question! Is any way to serialize all the dates given a
preference to SELECT and delay the insert and update.
I am building a Small Library in C & SQLite that will be under GPL , is
something like Lucene. Please help me how to give a preference to SELECT and
a delay to INSERT
OK! I understand Igor!
Thanks 4 your help!
On 7/26/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
Cesar David Rodas Maldonado
<[EMAIL PROTECTED]> wrote:
> I wanted to ask how can i know if a given text is UTF8 or ISO-8859-1?
You can't really. You need to have some metada
Thanks peter! :D
On 7/26/06, Peter Cunderlik <[EMAIL PROTECTED]> wrote:
> I wanted to ask how can i know if a given text is UTF8 or ISO-8859-1?
If you need conversions, the simplest would be to do it manually using
look-up tables. AFAIK none of the Latin-1 characters take more than 2
bytes in
n 7/26/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
> How can i know if a given text is UTF8 or ascii? and how can i convert
> between ascii to UTF8?
>
>
--
Cory Nelson
http://www.int64.org
How can i know if a given text is UTF8 or ascii? and how can i convert
between ascii to UTF8?
So, is imposible to read alway and write one per time... ?
On 7/25/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
I just want to read always and write one time.. understand? is that
imposible?
On 7/25/06, Robert Simpson <[EMAIL PROTECTED] > wrote:
>
> >
I just want to read always and write one time.. understand? is that
imposible?
On 7/25/06, Robert Simpson <[EMAIL PROTECTED]> wrote:
> -Original Message-
> From: Cesar David Rodas Maldonado [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 25, 2006 8:07 AM
> To: sqlit
Hello!
The weekend I was reading a book "Programming in Linux" and I found
something for me very cool!. I so that you could Lock a File for write but
just a part of the file. And I am wondering if in Linux SQLite would be able
to lock just a Page of the B-tree when you are doing the insert and
wrote:
Cesar David Rodas Maldonado wrote:
> Hello to everybody
>
> If I have a table with 100.000 unique words I am wondering if SQLite
> select
> if faster an cheaper (RAM, Processor, etc), or If i have to help SQLite
> using a Hash function, and what could be that Hash funct
I have not a substring, I have a list of words (stemmed words of several
languages) and i just want to get the Id. The word is unique
Hello to everybody
If I have a table with 100.000 unique words I am wondering if SQLite select
if faster an cheaper (RAM, Processor, etc), or If i have to help SQLite
using a Hash function, and what could be that Hash function?
Thanks.
D. Richard Hipp...
You are amazing!!! Thanks a lot for Sqlite and for help me!
God save D. Richard Hipp!
On Wed, 19 2006 17:44:46 -0400, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
"Cesar David Rodas Maldonado" <[EMAIL PROTECTED]> wrote:
> I need a funcion from
I compile SQLITE 3 source into my APP, but i will like to use like mysql
uses ( the COMPRESS() function into the sql), understand?
Do you know for how much money?
On 7/19/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
The author of Sqlite also sells a version that compresses and encrypts
the database.
On 7/19/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
> Thanks Hugh, i think it will b
Thanks Hugh, i think it will be useful for me...
On Wed, 19 Jul 2006 16:07 +0100 (BST), Hugh Gibson <[EMAIL PROTECTED]>
wrote:
You could try http://web.utk.edu/~jplyon/sqlite/code/sqaux-userfns.c but
it's a little old now.
Hugh
I need a funcion from compress a row with Zlib and I am wondering if SQLite
support or if someone did it and want to share him or her code.
Thanks to all
Thanks Christian :D
On 7/17/06, Christian Smith <[EMAIL PROTECTED]> wrote:
Cesar David Rodas Maldonado uttered:
> I am wondering if it will have a better performance if i split every
index
> and table into different files, i know that i will loose the LITE
concept,
> but
I don't know I just was wondering... but i think it will be faster if you
have a really great DB and when you and insert just will be locked the
table where you are doing the insert not the whole DB... what do you think?
I am wondering if it will have a better performance if i split every index
and table into different files, i know that i will loose the LITE concept,
but i am wondering if it will have a better performance...
Hello to everybody...!!!
I was using my old notebook the weekend, and i was doing some programs in C
to try SQLite performance, and I am happy, because i could insert
4.000.000rows in 10 minutes in my old notebook( Pentium II 400 MHZ 128
M.RAM). Thank for everybody who made it possible (share
Richard Hipp :
Thanks for explain me that... so what do you think will be the solution?
what do you think about db in Clustering.
On 7/13/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
"Cesar David Rodas Maldonado" <[EMAIL PROTECTED]> wrote:
> About the concurren
bedded application.
For a heavy duty application 64 bits hardware and OS would be the best.
Cesar David Rodas Maldonado wrote:
> I don't care about hardware... i will do cluster... but which DB motor
do
> think will be good for work with great velocity in select (sqlite,
> postgresql or mysql).
night.
- Original Message -
From: "Jay Sprenkle" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Wednesday, July 12, 2006 3:15 PM
Subject: Re: [sqlite] Question about database?
> On 7/12/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
>&g
e size of the key, only holds numbers up to 2 or 4 billion.
You said you have 8 billion rows.
You need a 64 bit version or to split up the data into many tables.
On 7/12/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
> So Jay... Do you think that i have to use a PC of 64 bit
So Jay... Do you think that i have to use a PC of 64 bits, or 32bits pc with
clustering?
On 7/12/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
> Hello to everybody!
>
> I want to ask to the people something... If i have a table with about
> 8.000.000.000 registers, and i have to do a select in
Hello to everybody!
I want to ask to the people something... If i have a table with about
8.000.000.000 registers, and i have to do a select in a numeric row that
will have index. what db do you recommend to me for use?
Thanxs (:D) people!
Hello to everybody!
I want to ask to the people something... If i have a table with about
8.000.000.000 registers, and i have to do a select in a numeric row that
will have index. what db do you recommend to me for use?
Thanxs (:D) people!
No se preocupen, los latinos estamos presentes en SQLite!!!
arriba el español
On 7/8/06, C.Peachment <[EMAIL PROTECTED]> wrote:
Penso que el primer sitio es mas hoy en dia.
No necessita dar disculpa para tu ingles.
No tengamos problemas entender.
Vosotro facilidad con ingles es mejor que
I have a question for every body...
SQLite was very slow for my inserts (like 5 inserts), with out
sincronization
but when i put BEGIN; before start with my inserts is was faster... like
1000 times more... :D why is that?
On 6/28/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]>
I dont know a lot about MySQL... but mysql is not so faster as you think...
I have in my computer the mysql 5 is good, but sqlite is so faster too!!!
but MySQL has a query cache so i think the cache make it seems more
faster than sqlite...
On 6/27/06, Péter Szabó <[EMAIL PROTECTED]>
Please i beg to every one
some one can give me some link or a little of theory of how can i do for
write at same time in a database like the others databases???
please i want to do that..
I am developing something for that.
where can i send you my script? (is done in C)
On 6/5/06, Stefan de Konink <[EMAIL PROTECTED]> wrote:
On Mon, 5 Jun 2006, Cesar David Rodas Maldonado wrote:
> i am interesting to do something for sqlite, and i was thinking to try
to do
> a mul
hello
i am interesting to do something for sqlite, and i was thinking to try to do
a multi threading for read and write at the same time, like MySQL, or i
would like to do something for fulltext search.
Please people answer me giving me ideas!!!
Thanks Richard Hipp and it will be more easy to use all in one file...
thanks for your help
On 4/16/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> "Cesar David Rodas Maldonado" <[EMAIL PROTECTED]> wrote:
> > any one can answer me?
> >
> > O
Hello
I have a software that uses four tables.
that's ok.. but i wanna know if is faster if i use for every table a
database ( a file) or if is the same thing in velocity if a put all the
tables in one file, couse every table uses a lot of data.
thanks
ll be in a
> better position to ask more detailed and to the point questions.
> General cries for help pretty much go unnoticed here.
>
> Most everyone here does not have the time and especially the patience
> required to teach an SQLite beginner how to write a Google replacement
Please people help me :D, the project will be open source...
On 4/4/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
>
> OK English is not my first language, i am from south America, from
> Paraguay so i speak Spanish...
>
> I am doing a project in C multiplatafo
ain what you are doing. How do you access SQLITE? What
> language? What SQL are you using. How many concurrent users do you
> have? Are you getting a LOCK error because of multiple users?
>
> Cesar David Rodas Maldonado wrote:
> > please i need some help
> > On 4/3/06,
please i need some help
On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
>
> i insert numbers and select numbers, so what could be the solutions,
> couse i have to do that
>
>
> On 4/3/06, Pam Greene < [EMAIL PROTECTED]> wrote:
> >
> >
ation of why what you want isn't a good idea, see any
> discussion of an "ACID" database, for example
> http://en.wikipedia.org/wiki/ACID .
>
> - Pam
>
> On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
> >
> > HElp me, couse i just need
HElp me, couse i just need to do insert and select, i dont use delete or
replate or update
On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
>
> thanx man
>
>
> but is posible open several DATABASE with a programm and do transaccion
> without locked the tab
thanx man
but is posible open several DATABASE with a programm and do transaccion
without locked the table???
On 4/3/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
>
> On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
> > I have a database ok... i do a
wrote:
>
> On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
> > I have a database that i do a lot of insert and select... really a lot
> >
> > but i have a problem with the lock database, couse when i do a lot of
> insert
> > i can do a selec
I have a database that i do a lot of insert and select... really a lot
but i have a problem with the lock database, couse when i do a lot of insert
i can do a select
i know that that is normal, but how can i fix it?, using a memory for insert
or using another database like a mirror or how???
why do you want to unsuscribe?
On 4/1/06, z-axis <[EMAIL PROTECTED]> wrote:
>
> thanks
>
>
-- Forwarded message --
From: Cesar David Rodas Maldonado <[EMAIL PROTECTED]>
Date: Apr 2, 2006 10:51 PM
Subject: how to fix problem of lock
To: SQLIte help <[EMAIL PROTECTED]>
I have a database that i do a lot of insert and select... really a lot
but i ha
76 matches
Mail list logo