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

[REBOL] network timeout with mysql-protocol.r 0.8.5

From: ryan:christiansen:intellisol at: 26-Mar-2001 15:36

The MySQL scheme for /Core is pretty nice so far. But I frequently encounter network timeouts, often when it has been less than 90 seconds since the last activity. Do I need to 'open and 'close the database for each entry? Is it common for a database connection to timeout so quickly? (I'm new at using SQL of any kind, but REBOL is getting me there.) Here is my script: REBOL [] do %mysql-protocol.r print "MySQL protocol loaded" print newline database: open mysql://username:[password--localhost]/test print "Test database loaded" print newline forever [ print "Author:" author: input print "Subject:" subject: input print "Content:" content: input insert database ["insert into messages values (?,?,?)" author subject content] print "Values inserted into table" probe read join mysql://username:[password--localhost]/test? "select * from messages" ] Ryan C. Christiansen Web Developer Intellisol International 4733 Amber Valley Parkway Fargo, ND 58104 701-235-3390 ext. 6671 FAX: 701-235-9940 Global Leader in People Performance Software _____________________________________ Confidentiality Notice This message may contain privileged and confidential information. If you think, for any reason, that this message may have been addressed to you in error, you must not disseminate, copy or take any action in reliance on it, and we would ask you to notify us immediately by return email to [ryan--christiansen--intellisol--com]