[REBOL] SQL, driver or me? (was: Re: Re: [ANN] (but what should I call it?))
From: hallvard::ystad::helpinhand::com at: 23-Jun-2003 20:24
Hi folks,
Dixit Ingo Hohmann (17.56 11.05.2003):
>For MySQL access you don't need /Pro, DocKimbels /Core driver is available through softinnov
( http://www.softinnov.com ) at
>http://rebol.softinnov.org/mysql/
Brilliant! Excellent! Fantastic!
..but I have a problem.
I'm trying to move the rebol pages search thing into an SQL database. For testing purposes,
I have a table of approx. 700 rows. When I try to "SELECT * FROM reburls", the SQL connection
hangs. trace/net on reveals the problem like this:
URL Parse: root none localhost none none rebindex
Net-log: ["Opening" "tcp" "for" "mySQL"]
connecting to: localhost
Net-log: ["low level read of " 4 "bytes"]
Net-log: ["low level read of " 42 "bytes"]
Net-log: {
----- Server ------
Version: 4.0.12-nt
Protocol version: 10
Thread ID: 81
Crypt Seed: o!OMs|4.
Capabilities: [
long-flag
connect-with-db
compress
transactions]
-------------------}
Net-log: ["low level read of " 4 "bytes"]
Net-log: ["low level read of " 3 "bytes"]
Net-log: "Connected to server. Handshake OK"
Net-log: "sending ping..."
Net-log: ["low level read of " 4 "bytes"]
(...)
Net-log: ["low level read of " 584 "bytes"]
Net-log: ["low level read of " 1341 "bytes"]
Net-log: ["low level read of " 0 "bytes"]
Net-log: ["low level read of " 0 "bytes"]
Net-log: ["low level read of " 0 "bytes"]
Net-log: ["low level read of " 0 "bytes"]
Net-log: ["low level read of " 0 "bytes"]
Net-log: ["low level read of " 0 "bytes"]
Net-log: ["low level read of " 0 "bytes"]
Net-log: ["low level read of " 0 "bytes"]
Net-log: ["low level read of " 0 "bytes"]
So suddenly, it seems that there are no more bytes to get. The "MySQL Control Center"
from mysql.com does not behave like there's anything wrong, so I don't think MySQL's
got anything to do with it. The question is, is it me or the SQL driver?
So I tried with LIMIT. "SELECT * FROM reburls LIMIT 1" Works fine. I get one record,
i.e. one row from the table. But "SELECT * FROM reburls LIMIT 2" hangs... And I have
no idea why.
So am I the problem? What did I do wrong? Or is this a bug in Dockimbel's mysql driver?
(I find it highly probable that I am the problem, but I cannot see how). Any tips very
much appreciated.
~H
Oh, and by the way, the indexer (http://folk.uio.no/hallvary/rebindex/) has indexed about
10,000 pages now. I fear a great number of them are duplicates (my oh my, such lousy
programming!). And as I am simply using a file to save all these web pages, searching
takes quite some time. A quick search just now took 31 seconds... So...