Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

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