SQL, driver or me? (was: Re: Re: [ANN] (but what should I call it?))

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...

Hi Hallvard: I use mysql-protocol extensively and have not encountered this problem. And this is a very simple query.

I am using version 3.23.41 on my Linux work station, and am using queries on remote servers on the same version on Linux and Sun servers. I'm guessing that you are attempting to 'talk' to ver 4.0.12 on an NT server? Am I correct? If so, can you run a similar test on a different server and/or version. Also, have you executed any other queries from this server successfully? tim

-- Tim Johnson <[tim--johnsons-web--com]> http://www.alaska-internet-solutions.com http://www.johnsons-web.com

Indeed.

I'm on my home machine, a win2k home edition. I'm aiming for deployment on a mac, but testing, so far, on my home machine.

Oh yes. I've put in the 700 rows successfully. If I delete them with the admin tool, everything behaves normally again. Nothing hangs. But once I put in some rows, it seems to hang... I'll try to get it up and running on the mac to test it there. I'll get back to it once that's clear. ~H

I was hoping that DocKimbel would speak up but I'll advance how I would begin to approach this: I'd start with the simplest of tables. One record, one column. I would attempt 'select * from table and if that worked, I would then proceed to increase the number of records and the number of columns. ... until failure occured... If that didn't work, then I would try the same with different OS's both the rebol and MySql end.... Let me know how it goes on the Mac. Are you using OS (10 I think) with the Unix-style Kernel? tim

-- Tim Johnson <[tim--johnsons-web--com]> http://www.alaska-internet-solutions.com http://www.johnsons-web.com