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

[REBOL] Re: SQL, driver or me?

From: tim:johnsons-web at: 23-Jun-2003 20:56

* Hallvard Ystad <[hallvard--ystad--helpinhand--com]> [030623 13:59]:
> Dixit Tim Johnson (21.26 23.06.2003): > > Hi Hallvard: > > I use mysql-protocol extensively and have not encountered > > this problem. And this is a very simple query. > > Indeed. > > > > Version: 4.0.12-nt > > 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. > > 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. > > > Also, have you executed any other queries from this > > server successfully? > > 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.
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
> ~H > > > tim > > > >> 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... > >> > >> > >> Prętera censeo Carthaginem esse delendam > >> > >> -- > >> To unsubscribe from this list, please send an email to > >> [rebol-request--rebol--com] with "unsubscribe" in the > >> subject, without the quotes. > > > >-- > >Tim Johnson <[tim--johnsons-web--com]> > > http://www.alaska-internet-solutions.com > > http://www.johnsons-web.com > >-- > >To unsubscribe from this list, please send an email to > >[rebol-request--rebol--com] with "unsubscribe" in the > >subject, without the quotes. > > Prętera censeo Carthaginem esse delendam > > -- > To unsubscribe from this list, please send an email to > [rebol-request--rebol--com] with "unsubscribe" in the > subject, without the quotes.
-- Tim Johnson <[tim--johnsons-web--com]> http://www.alaska-internet-solutions.com http://www.johnsons-web.com