Re: SQL

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 56169
interpreted = N
texte = Donovan Brooke wrote: > 1.) Machine that is an SQL data server. It sits inside a > WAN maybe. It is has redundancy and fail-safe measures implemented. True, as long as this is MySQL (which is all 6.0 supports natively). You can still use ODBC to connect to some other SQL platform (if you have a real high tolerance for pain ;~). > > 2.) POS machines at the physical store fronts (different geographical > locations) that access the remote SQL data server. How large are the data sets being transferred? If your SQL queries are all very targeted (i.e. return at most 100 records), you will be OK here. WAN queries that return large numbers of records will kill your performance. > > 3.) WebDNA server that accesses the data server. > > My theory is that this could provide a realtime (or almost realtime) > inventory structure. An alternative method is to have replicated databases (which MySQL does out of the box) for the slowly changing data (i.e. the full-text lookups). Then do direct queries only for records which affect inventory (for example). This would be _much_ more scalable in the long run. John -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5748 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] My SQL will not Connect (Solved) (Frederick Weber 2020)
  2. Re: [WebDNA] My SQL will not Connect (Stuart Tremain 2020)
  3. Re: [WebDNA] My SQL will not Connect (Frederick Weber 2020)
  4. Re: [WebDNA] My SQL will not Connect (Frederick Weber 2020)
  5. Re: [WebDNA] My SQL will not Connect (Frederick Weber 2020)
  6. Re: [WebDNA] My SQL will not Connect (Stuart Tremain 2020)
  7. Re: [WebDNA] My SQL will not Connect (Frederick Weber 2020)
  8. Re: [WebDNA] My SQL will not Connect (Stuart Tremain 2020)
  9. [WebDNA] My SQL will not Connect (Frederick Weber 2020)
  10. RE: EXTERNAL EMAIL: RE: [WebDNA] [BULK] SQL ODBC 00000 Error ("Buske, Matthew" 2019)
  11. RE: EXTERNAL EMAIL: RE: [WebDNA] [BULK] SQL ODBC 00000 Error ("Buske, Matthew" 2019)
  12. RE: EXTERNAL EMAIL: RE: [WebDNA] [BULK] SQL ODBC 00000 Error ("Terry Nair" 2019)
  13. Re: EXTERNAL EMAIL: RE: [WebDNA] [BULK] SQL ODBC 00000 Error (Donovan Brooke 2019)
  14. RE: EXTERNAL EMAIL: RE: [WebDNA] [BULK] SQL ODBC 00000 Error ("Buske, Matthew" 2019)
  15. RE: EXTERNAL EMAIL: RE: [WebDNA] [BULK] SQL ODBC 00000 Error ("Terry Nair" 2019)
  16. RE: EXTERNAL EMAIL: RE: [WebDNA] [BULK] SQL ODBC 00000 Error ("Buske, Matthew" 2019)
  17. RE: [WebDNA] [BULK] SQL ODBC 00000 Error ("Terry Nair" 2019)
  18. [WebDNA] [BULK] SQL ODBC 00000 Error ("Buske, Matthew" 2019)
  19. Re: [WebDNA] SQL with Webdna - good ideas? (Stuart Tremain 2018)
  20. [WebDNA] SQL with Webdna - good ideas? (Noah Valley 2018)
  21. Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
  22. Re: [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
  23. Re: [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
  24. Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
  25. Re: [WebDNA] Connect to MS SQL (Donovan Brooke 2013)
  26. Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
  27. Re: [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
  28. Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
  29. Re: [WebDNA] WebDNA & MS SQL (Stuart Tremain 2013)
  30. [WebDNA] WebDNA & MS SQL (Stuart Tremain 2013)
  31. Re: [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
  32. Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
  33. Re: [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
  34. Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
  35. Re: [WebDNA] Connect to MS SQL (Jeffrey Jones 2013)
  36. Re: [WebDNA] Connect to MS SQL (Jeffrey Jones 2013)
  37. [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
  38. [WebDNA] WebDNA / SQL / LDAP (active directory) Solved (Alex McCombie 2013)
  39. [WebDNA] SQL in v7.x ? (WebDNA Solutions 2013)
  40. Re: [WebDNA] No more SQL in 7.1? (Govinda 2012)
  41. Re: [WebDNA] No more SQL in 7.1? (sal danna 2012)
  42. Re: [WebDNA] No more SQL in 7.1? (Jeffrey Jones 2012)
  43. Re: [WebDNA] No more SQL in 7.1? (christophe.billiottet@webdna.us 2012)
  44. Re: [WebDNA] No more SQL in 7.1? (frank@cwolfe.com 2012)
  45. Re: [WebDNA] No more SQL in 7.1? (Govinda 2012)
  46. Re: [WebDNA] No more SQL in 7.1? (sal danna 2012)
  47. Re: [WebDNA] No more SQL in 7.1? (aaronmichaelmusic@gmail.com 2012)
  48. Re: [WebDNA] No more SQL in 7.1? (Kenneth Grome 2012)
  49. Re: [WebDNA] No more SQL in 7.1? (Govinda 2012)
  50. Re: [WebDNA] No more SQL in 7.1? (Kenneth Grome 2012)
  51. Re: [WebDNA] No more SQL in 7.1? (Donovan Brooke 2012)
  52. Re: [WebDNA] No more SQL in 7.1? ("Psi Prime Inc, Matthew A Perosi " 2012)
  53. Re: [WebDNA] No more SQL in 7.1? (christophe.billiottet@webdna.us 2012)
  54. Re: [WebDNA] No more SQL in 7.1? (Stuart Tremain 2012)
  55. Re: [WebDNA] No more SQL in 7.1? (frank@cwolfe.com 2012)
  56. Re: [WebDNA] No more SQL in 7.1? (aaronmichaelmusic@gmail.com 2012)
  57. Re: [WebDNA] No more SQL in 7.1? (Stuart Tremain 2012)
  58. Re: [WebDNA] No more SQL in 7.1? (christophe.billiottet@webdna.us 2012)
  59. Re: [WebDNA] No more SQL in 7.1? (Govinda 2012)
  60. Re: [WebDNA] No more SQL in 7.1? (christophe.billiottet@webdna.us 2012)
  61. Re: [WebDNA] No more SQL in 7.1? (Stuart Tremain 2012)
  62. Re: [WebDNA] No more SQL in 7.1? (christophe.billiottet@webdna.us 2012)
  63. Re: [WebDNA] No more SQL in 7.1? (aaronmichaelmusic@gmail.com 2012)
  64. Re: [WebDNA] No more SQL in 7.1? (christophe.billiottet@webdna.us 2012)
  65. Re: [WebDNA] No more SQL in 7.1? (bob.minor@cybermill.com 2012)
  66. Re: [WebDNA] No more SQL in 7.1? (Donovan Brooke 2012)
  67. Re: [WebDNA] No more SQL in 7.1? (christophe.billiottet@webdna.us 2012)
  68. [WebDNA] No more SQL in 7.1? (aaronmichaelmusic@gmail.com 2012)
  69. Re: [WebDNA] SQLdisconnect / sqlrelease (christophe.billiottet@webdna.us 2011)
  70. [WebDNA] SQLdisconnect / sqlrelease (Tommy Bell 2011)
  71. Re: [WebDNA] SQL Search (Rob 2010)
  72. Re: [WebDNA] SQL Search (Paul Willis 2010)
  73. [WebDNA] SQL Search (Rob 2010)
  74. RE: [WebDNA] SQLExecute Memory Leak ("Sarah Nussbaum" 2008)
  75. Re: [WebDNA] SQLExecute Memory Leak (Greg Kesler 2008)
  76. [WebDNA] SQLExecute Memory Leak ("Sarah Nussbaum" 2008)
  77. Re: SQL Query with % ( Clint Davis 2007)
  78. SQL Query with % ( Clint Davis 2007)
  79. SQL Error ( Clint Davis 2007)
  80. WebDNA and SQL - encrypted passwords ( Larry Hewitt 2006)
  81. Re: SQLResult chokes on null values? ( "Olin Lagon" 2006)
  82. Re: SQLResult chokes on null values? ( "Adam O'Connor" 2006)
  83. SQLResult chokes on null values? ( "Olin Lagon" 2006)
  84. Re: SQL db type ( Stuart Tremain 2006)
  85. Re: SQL db type ( "Nitai @ ComputerOil" 2006)
  86. Re: SQL db type ( "Nitai @ ComputerOil" 2006)
  87. Re: SQL db type ( Stuart Tremain 2006)
  88. Re: SQL db type ( "Nitai @ ComputerOil" 2006)
  89. Re: SQL db type ( Stuart Tremain 2006)
  90. Re: SQL db type ( "Bess Ho" 2006)
  91. Re: SQL db type ( Jesse Proudman 2006)
  92. Re: SQL db type ( Alex McCombie 2006)
  93. Re: SQL db type ( Jesse Proudman 2006)
  94. SQL db type ( Stuart Tremain 2006)
  95. Re: Here we go again...WebDNA - SQL- Clustering ( Kenneth Grome 2006)
  96. Re: Here we go again...WebDNA - SQL- Clustering ( "Bess Ho" 2006)
  97. Re: Here we go again...WebDNA - SQL- Clustering ( Donovan Brooke 2006)
  98. Re: Here we go again...WebDNA - SQL- Clustering ( "Bess Ho" 2006)
  99. Re: Here we go again...WebDNA - SQL- Clustering ( "Bess Ho" 2006)
  100. Re: Here we go again...WebDNA - SQL- Clustering ( Alex McCombie 2006)
  101. Re: Here we go again...WebDNA - SQL- Stored Procedures ( Alex McCombie 2006)
  102. Re: Here we go again...WebDNA - SQL- Clustering ( Donovan Brooke 2006)
  103. Re: Here we go again...WebDNA - SQL- Clustering ( Donovan Brooke 2006)
  104. Re: Here we go again...WebDNA - SQL- Clustering ( Adam O'Connor 2006)
  105. Re: Here we go again...WebDNA - SQL- Clustering ( nitai@computeroil.com 2006)
  106. Re: Here we go again...WebDNA - SQL- Clustering ( Donovan Brooke 2006)
  107. Re: Slightly OT - SQL- Clustering ( Adam O'Connor 2006)
  108. Re: Slightly OT - SQL- Clustering ( Clint Davis 2006)
  109. Slightly OT - SQL- Clustering ( Pat McCormick 2006)
  110. Re: Here we go again...WebDNA - SQL- Clustering ( Alex McCombie 2006)
  111. Re: Here we go again...WebDNA - SQL- Stored Procedures ( Adam O'Connor 2006)
  112. Re: Here we go again...WebDNA - SQL- Clustering ( nitai@computeroil.com 2006)
  113. Re: Here we go again...WebDNA - SQL- Clustering ( Donovan Brooke 2006)
  114. Re: Here we go again...WebDNA - SQL- Clustering ( Alex McCombie 2006)
  115. Re: Here we go again...WebDNA - SQL- Clustering ( Bob Minor 2006)
  116. Re: Here we go again...WebDNA - SQL- Clustering ( Stuart Tremain 2006)
  117. Re: Here we go again...WebDNA - SQL- Clustering ( Adam O'Connor 2006)
  118. Re: Speaking of mysql... sqlexecute question ( "Adam O'Connor" 2006)
  119. Speaking of mysql... sqlexecute question ( Phil Herring 2006)
  120. Re: Webcat and SQL - General Comments ( "Adam O'Connor" 2006)
  121. Re: Webcat and SQL - General Comments ( Alex McCombie 2006)
  122. Webcat and SQL - General Comments ( "Adam O'Connor" 2006)
  123. Re: Cleaning strings for SQL with WebCat ( "Adam O'Connor" 2005)
  124. Re: Cleaning strings for SQL with WebCat ( "Nitai @ ComputerOil" 2005)
  125. Re: Cleaning strings for SQL with WebCat ( "Adam O'Connor" 2005)
  126. Re: Cleaning strings for SQL with WebCat ( Donovan Brooke 2005)
  127. Cleaning strings for SQL with WebCat ( "Adam O'Connor" 2005)
  128. Re: SQLCONNECT ( "kalin mintchev" 2005)
  129. Re: SQLCONNECT ( "Nitai @ ComputerOil" 2005)
  130. Re: SQLCONNECT ( "kalin mintchev" 2005)
  131. Re: SQLCONNECT ( "Nitai @ ComputerOil" 2005)
  132. Re: SQLCONNECT ( "kalin mintchev" 2005)
  133. Re: SQLCONNECT ( "kalin mintchev" 2005)
  134. Re: SQLCONNECT ( "kalin mintchev" 2005)
  135. Re: SQLCONNECT ( "kalin mintchev" 2005)
  136. SQLCONNECT ( "kalin mintchev" 2005)
  137. Re: Problems with sql: "not supported" ( Marco Bambini 2005)
  138. Re: Problems with sql: "not supported" ( nitai@computeroil.com 2005)
  139. Re: Problems with sql: "not supported" ( "Sonia Stella" 2005)
  140. Re: Problems with sql: "not supported" ( Kenneth Grome 2005)
  141. Problems with sql: "not supported" ( "Sonia Stella" 2005)
  142. Re: Failed SQL Query ( Clint Davis 2005)
  143. Re: Failed SQL Query ( Jesse Proudman 2005)
  144. Failed SQL Query ( Clint Davis 2005)
  145. Re: SQL Madness ( Alex McCombie 2005)
  146. Re: SQL Madness ( "Scott Anderson" 2005)
  147. Re: SQL Madness ( Alex McCombie 2005)
  148. Re: SQL Madness ( Jesse Proudman 2005)
  149. Re: SQL Madness ( "Scott Anderson" 2005)
  150. SQL Madness ( Alex McCombie 2005)
  151. Authenticating via SQL server ( Mark Derrick 2005)
  152. SQL Madness ( Alex McCombie 2005)
  153. SQL Problem ( Jesse Proudman 2005)
  154. ODBC Error: SQL not supported ( Alexander Kulak 2005)
  155. Retrieving binary from SQL ( "Nitai @ ComputerOil" 2005)
  156. sql protect routine ( Bob Minor 2005)
  157. Re: WebDNA and PostGres SQL ( "Nitai @ ComputerOil" 2005)
  158. Re: WebDNA and PostGres SQL ( John Peacock 2005)
  159. WebDNA and PostGres SQL ( "Erol Guneri" 2005)
  160. Correct SQL WebDNA Syntax ( Steve Craig 2005)
  161. Re: [OT] Visual Fox Pro vs. SQL ( "Will Starck" 2005)
  162. Re: [OT] Visual Fox Pro vs. SQL ( John Peacock 2005)
  163. [OT] Visual Fox Pro vs. SQL ( "Will Starck" 2005)
  164. Re: Slightly [OT] Trying to get clients SQL system going ( Steve Craig 2005)
  165. Re: Slightly [OT] Trying to get clients SQL system going ( John Peacock 2005)
  166. Re: Slightly [OT] Trying to get clients SQL system going ( Steve Craig 2005)
  167. Re: Slightly [OT] Trying to get clients SQL system going ( John Peacock 2005)
  168. Re: Slightly [OT] Trying to get clients SQL system going ( Steve Craig 2005)
  169. Re: Slightly [OT] Trying to get clients SQL system going ( John Peacock 2005)
  170. Slightly [OT] Trying to get clients SQL system going ( Steve Craig 2005)
  171. Re: [OT] Sybase vs. Pervasive SQL for WebDNA integration? ( Gary Krockover 2005)
  172. Re: [OT] Sybase vs. Pervasive SQL for WebDNA integration? ( John Peacock 2005)
  173. [OT] Sybase vs. Pervasive SQL for WebDNA integration? ( WJ Starck 2005)
  174. Re: WebDNA+unixODBC+MS SQL ( Jim Lanford 2005)
  175. WebDNA+unixODBC+MS SQL ( Alexander V. Butenko 2005)
  176. Re: SQL - Output into file ( "Jason Aus" 2004)
  177. Re: SQL - Output into file ( "Jason Aus" 2004)
  178. Re: SQL - Output into file ( Larry Hewitt 2004)
  179. Re: SQL - Output into file ( Brian Fries 2004)
  180. SQL - Output into file ( Larry Hewitt 2004)
  181. Re: SQL Error: 00000 ( "Doug Deck" 2004)
  182. Re: SQL Error: 00000 ( "Crist, Trevor" 2004)
  183. Re: SQL Error: 00000 ( Gary Krockover 2004)
  184. Re: SQL Error: 00000 ( "Crist, Trevor" 2004)
  185. FW: SQL Error: 00000 ( "Crist, Trevor" 2004)
  186. SQL Error: 00000 ( "Crist, Trevor" 2004)
  187. Re: SQL/ODBC (again) ( Jim Lanford 2004)
  188. SQL/ODBC (again) ( Clint Davis 2004)
  189. Re: SQL Connections ( Larry Hewitt 2004)
  190. Re: SQL Connections ( Brian Fries 2004)
  191. Re: SQLConnect to Oracle database ( Brian Fries 2004)
  192. SQL Connections ( Larry Hewitt 2004)
  193. SQLConnect to Oracle database ( edwin@hoevers.com 2004)
  194. Re: MS SQL (thats S not Y) ( "Doug Deck" 2004)
  195. MS SQL (thats S not Y) ( Philip Edell 2004)
  196. Re: OT- Move SQL DB's ( "Erol Guneri" 2004)
  197. Re: OT- Move SQL DB's ( John Peacock 2004)
  198. OT- Move SQL DB's ( "Nitai @ ComputerOil" 2004)
  199. Re: 6.0 SQL Question ( "Brian Boegershausen" 2004)
  200. Re: 6.0 SQL Question ( "Scott Anderson" 2004)
  201. 6.0 SQL Question ( Clint Davis 2004)
  202. Re: SQL Support in 6.0 ( "Steve Contreras" 2004)
  203. Re: SQL Support in 6.0 ( "Crist, Trevor" 2004)
  204. Re: SQL ( "Crist, Trevor" 2004)
  205. Re: SQL ( John Peacock 2004)
  206. Re: SQL ( Donovan Brooke 2004)
  207. Re: SQL ( John Peacock 2004)
  208. Re: SQL ( Glenn Busbin 2004)
  209. Re: SQL Support in 6.0 ( "Scott Anderson" 2004)
  210. Re: SQL ( Donovan Brooke 2004)
  211. SQL Support in 6.0 ( "Crist, Trevor" 2004)
  212. Re: SQL ( John Peacock 2004)
  213. WebDNA v6.0 MS SQL Server timeframe ( Karl Schroll 2004)
  214. SQL ( Donovan Brooke 2004)
  215. SQL ShoppingCarts v5.x ( Bob Minor 2003)
  216. Re: [OT] SQL Errors ( Matthew A Perosi 2003)
  217. SQL Errors ( Glenn Busbin 2003)
  218. can't get WebDNA to display my SQL primary keys via ODBC ( Lucas Rockwell 2003)
  219. Re: SQL ( Gary Krockover 2003)
  220. Re: SQL ( "Brian Boegershausen" 2003)
  221. Re: SQL ( "Morten Madsen" 2003)
  222. SQL ( "Brian Boegershausen" 2003)
  223. Re: Paging a SQL result... ( "WebDna @" 2003)
  224. Re: Paging a SQL result... ( John Hill 2003)
  225. Re: Paging a SQL result... ( "WebDna @" 2003)
  226. Re: Paging a SQL result... ( John Hill 2003)
  227. Paging a SQL result... ( "Morten Madsen" 2003)
  228. Re: WebDNA and SQL (Jay Van Vark 2003)
  229. Re: WebDNA and SQL (Dale's Stuff 2003)
  230. Re: WebDNA and SQL (Gary Krockover 2003)
  231. Re: WebDNA and SQL (Alain Russell 2003)
  232. Re: WebDNA and SQL (Phillip Bonesteele 2003)
  233. Re: WebDNA and SQL (Alain Russell 2003)
  234. Re: WebDNA and SQL (Alain Russell 2003)
  235. Re: WebDNA and SQL (Clint Davis 2003)
  236. Re: WebDNA and SQL (Alain Russell 2003)
  237. Re: WebDNA and SQL (Sal D'anna 2003)
  238. Re: WebDNA and SQL (Clint Davis 2003)
  239. Re: WebDNA and SQL (Jay Van Vark 2003)
  240. Re: WebDNA and SQL (Jay Van Vark 2003)
  241. Re: WebDNA and SQL (Nitai @ ComputerOil 2003)
  242. Re: WebDNA and SQL (Alain Russell 2003)
  243. Re: WebDNA and SQL (Clint Davis 2003)
  244. Re: WebDNA and SQL (Nitai @ ComputerOil 2003)
  245. Re: WebDNA and SQL (Gary Krockover 2003)
  246. Re: WebDNA and SQL (Nitai @ ComputerOil 2003)
  247. Re: WebDNA and SQL (Alain Russell 2003)
  248. Re: WebDNA and SQL (Nitai @ ComputerOil 2003)
  249. Re: WebDNA and SQL (Alain Russell 2003)
  250. Re: WebDNA and SQL (Nitai @ ComputerOil 2003)
  251. Re: WebDNA and SQL (Alain Russell 2003)
  252. WebDNA and SQL (Nitai @ ComputerOil 2003)
  253. Re: WebDNA + SQL Server (Michael Davis 2003)
  254. Re: WebDNA + SQL Server (Alain Russell 2003)
  255. Re: WebDNA + SQL Server (Brian Looper 2003)
  256. Re: WebDNA + SQL Server (Dan Strong 2003)
  257. Re: WebDNA + SQL Server (John Peacock 2003)
  258. WebDNA + SQL Server (Alain Russell 2003)
  259. Re: Converting SQL Microtime to Date and Time (Dan Strong 2003)
  260. Re: Converting SQL Microtime to Date and Time (Jesse Williams-Proudman 2003)
  261. Re: Converting SQL Microtime to Date and Time (Jesse Williams-Proudman 2003)
  262. Re: Converting SQL Microtime to Date and Time (Dan Strong 2003)
  263. Re: Converting SQL Microtime to Date and Time (sally 2003)
  264. Re: Converting SQL Microtime to Date and Time (John Peacock 2003)
  265. Re: Converting SQL Microtime to Date and Time (Jesse Williams-Proudman 2003)
  266. Re: Converting SQL Microtime to Date and Time (Frank Nordberg 2003)
  267. Re: Converting SQL Microtime to Date and Time (Glenn Busbin 2003)
  268. Re: Converting SQL Microtime to Date and Time (Jesse Williams-Proudman 2003)
  269. Re: Converting SQL Microtime to Date and Time (Glenn Busbin 2003)
  270. Converting SQL Microtime to Date and Time (Jesse Williams-Proudman 2003)
  271. Re: SQL, ODBC and MySql (Dale-Lists 2002)
  272. Re: SQL, ODBC and MySql (Le Pham 2002)
  273. Re: SQL statements (Jason Tyler 2002)
  274. Re: SQL statements (Ben Swihart 2002)
  275. Re: SQL statements (Bjørn Are Solstad 2002)
  276. Re: SQL statements (John Peacock 2002)
  277. Re: SQL statements (Jason Tyler 2002)
  278. Re: SQL statements (Clint Davis 2002)
  279. Re: SQL statements (dale's stuff 2002)
  280. Re: SQL statements (Jason Tyler 2002)
  281. Re: SQL statements (John Peacock 2002)
  282. Re: SQL statements (dale's stuff 2002)
  283. Re: SQL statements (Pedro Rivera 2002)
  284. Re: SQL statements (Jesse Williams-Proudman 2002)
  285. Re: SQL statements (Ben Swihart 2002)
  286. Re: SQL statements (Pedro Rivera 2002)
  287. Re: WebDNA vs SQL ? (Kenneth Grome 2002)
  288. Re: WebDNA vs SQL ? (James D. Wilson 2002)
  289. Re: WebDNA vs SQL ? (Ben Swihart 2002)
  290. Re: WebDNA vs SQL ? (Kenneth Grome 2002)
  291. Re: WebDNA vs SQL ? (James D. Wilson 2002)
  292. Re: WebDNA vs SQL ? (Robert Kudrle 2002)
  293. Re: WebDNA vs SQL ? (Alain Russell 2002)
  294. Re: WebDNA vs SQL ? (Donovan 2002)
  295. WebDNA vs SQL ? (James D. Wilson 2002)
  296. Re: SQL newbie (Brian Wachter 2002)
  297. Re: SQL newbie (Pedro Rivera 2002)
  298. Re: sql or not sql (John Peacock 2002)
  299. sql or not sql (Arturo Vargas 2002)
  300. Online SQL Resources (John Peacock 2001)
  301. Re: SQL Error 22003 : Found the workaround (Scott Anderson 2001)
  302. Re: SQL Error 22003 : Found the workaround (John Peacock 2001)
  303. Re: SQL Error 22003 : Found the workaround (trevor crist 2001)
  304. Re: SQL Error 22003 (trevor crist 2001)
  305. Re: SQL Error 22003 (trevor crist 2001)
  306. Re: SQL Error 22003 (Scott Anderson 2001)
  307. Re: SQL speed issues (John Peacock 2001)
  308. Re: SQL Query Question (Andrew Simpson 2001)
  309. Re: SQL Query Question (Britt T. 2001)
  310. Re: [OT] was Re: SQL Query Question (Charles Kline 2001)
  311. Re: [OT] was Re: SQL Query Question (John Peacock 2001)
  312. Re: SQL Query Question (Charles Kline 2001)
  313. [OT] was Re: SQL Query Question (John Peacock 2001)
  314. Re: SQL Query Question (John Hill 2001)
  315. Re: sql context issues (Peter Werno 2001)
  316. Re: Typhoon/Pro do SQL? (John Peacock 2001)
  317. Typhoon/Pro do SQL? (Sam Lewis 2001)
  318. Re: Accessing SQL server from OSX (Alain Russell 2001)
  319. Re: Accessing SQL server from OSX (Jim Lanford 2001)
  320. Re: Accessing SQL server from OSX (Andrew Simpson 2001)
  321. Accessing SQL server from OSX (Alain Russell 2001)
  322. Re: Error: SQL not supported (Bjørn Are Solstad 2001)
  323. Error: SQL not supported (Steve Craig 2001)
  324. Re: SQL on OSX Client (Sam Lewis 2001)
  325. Re: when to use SQL over webcat? (Paul Uttermohlen 2000)
  326. when to use SQL over webcat? (John Butler 2000)
  327. Re: SQL on Linux - Howto? (WebDNA Support 2000)
  328. [Request] - SQL Search (Nicolas Verhaeghe 2000)
  329. Re: mySQL or MS SQL (John Peacock 2000)
  330. mySQL or MS SQL (adam@inos.com (Adam O'Connor) 2000)
  331. Re: mySQL or MS SQL (John 2000)
  332. Re[2]: [REQ] Improved SQL context (jpeacock@univpress.com 2000)
  333. Re: [REQ] Improved SQL context (Grant Hulbert 2000)
  334. [REQ] Improved SQL context (Nicolas Verhaeghe 2000)
  335. Re: [OT] SQL and Crackers (WebDNA Support 2000)
  336. Re: [OT] SQL and Crackers (Nicolas Verhaeghe 2000)
  337. Re: [OT] SQL and Crackers (Nicolas Verhaeghe 2000)
  338. Re: [OT] SQL and Crackers (Clint Davis 2000)
  339. Re: [OT] SQL and Crackers (Nicolas Verhaeghe 2000)
  340. [OT] SQL and Crackers (Glenn Busbin 2000)
  341. [Feature Request] SQL error filter (Nicolas Verhaeghe 2000)
  342. Re: Macs and SQL (Nicolas Verhaeghe 2000)
  343. Macs and SQL (Glenn Busbin 2000)
  344. Re: MacOS 9 => ODBC=> Ms SQL Server 7 (Nicolas Verhaeghe 2000)
  345. Re: MacOS 9 => ODBC=> Ms SQL Server 7 (Aaron Chute 2000)
  346. MacOS 9 => ODBC=> Ms SQL Server 7 (Nicolas Verhaeghe 2000)
  347. Re: [SQL] on MacOs to SQL Server ... HOW TO? (Nicolas Verhaeghe 2000)
  348. Re: [SQL] on MacOs to SQL Server ... HOW TO? (WebDNA Support 2000)
  349. Re: [SQL] on MacOs to SQL Server ... HOW TO? (Nicolas Verhaeghe 2000)
  350. Re: [SQL] on MacOs to SQL Server ... HOW TO? (WebDNA Support 2000)
  351. Re: [SQL] on MacOs to SQL Server ... HOW TO? (Nicolas Verhaeghe 2000)
  352. [SQL] on MacOs to SQL Server ... HOW TO? (Nicolas Verhaeghe 2000)
  353. Re: WEBCAT with SQL backend. Help please! (helene 2000)
  354. Re: WEBCAT with SQL backend. Help please! (helene 2000)
  355. Re: WEBCAT with SQL backend. Help please! (WebDNA Support 2000)
  356. Re: WEBCAT with SQL backend. Help please! (WebDNA Support 2000)
  357. Re: WEBCAT with SQL backend. Help please! (helene 2000)
  358. Re: WEBCAT with SQL backend. Help please! (helene 2000)
  359. Re: WEBCAT with SQL backend. Help please! (WebDNA Support 2000)
  360. Re: WEBCAT with SQL backend. Help please! (WebDNA Support 2000)
  361. WEBCAT with SQL backend. Help please! (helene 2000)
  362. WEBCAT with SQL backend. Help please! (helene 2000)
  363. Re: SQL Changes in 3.0.7? (Paul Willis 2000)
  364. Record Modified Date - SQL ? (Anup Setty 2000)
  365. Re: SQL Changes in 3.0.7? (Nicolas Verhaeghe 2000)
  366. Re: SQL Changes in 3.0.7? (Grant Hulbert 2000)
  367. Re: SQL Changes in 3.0.7? (Nicolas Verhaeghe 2000)
  368. Re: SQL connection - Solved (Nicolas Verhaeghe 2000)
  369. Re: SQL connection (Nicolas Verhaeghe 2000)
  370. Re: Detecting NULL value in returned SQL (WebDNA Support 2000)
  371. Detecting NULL value in returned SQL (Howard Wolosky 2000)
  372. Re: SQL Support (Nicolas Verhaeghe 2000)
  373. Re: SQL / Webcat Help (Anup Setty 1999)
  374. Re: SQL / Webcat Help (jpeacock@univpress.com 1999)
  375. Re: SQL / Webcat Help (djones@augustmartin.net (August Martin - Dave Jones) 1999)
  376. Re: SQL in SEARCH breaks FOUNDITEMS (djones@augustmartin.net (August Martin - Dave Jones) 1999)
  377. Re: SQL in SEARCH breaks FOUNDITEMS (PCS Technical Support 1999)
  378. Re: SQL Ref. (PCS Technical Support 1999)
  379. Re: SQL Ref. (Tim Taylor 1999)
  380. Re: Web Cat and MS SQL 6.5 (PCS Technical Support 1999)
  381. Web Cat and MS SQL 6.5 (Ron Verbaas 1999)
  382. Re: Integration with SQL (Grant Hulbert 1997)
  383. Integration with SQL (Andy Meng 1997)
  384. WebDNA database access and the future of SQL (Patrick McCormick WebD)
Donovan Brooke wrote: > 1.) Machine that is an SQL data server. It sits inside a > WAN maybe. It is has redundancy and fail-safe measures implemented. True, as long as this is MySQL (which is all 6.0 supports natively). You can still use ODBC to connect to some other SQL platform (if you have a real high tolerance for pain ;~). > > 2.) POS machines at the physical store fronts (different geographical > locations) that access the remote SQL data server. How large are the data sets being transferred? If your SQL queries are all very targeted (i.e. return at most 100 records), you will be OK here. WAN queries that return large numbers of records will kill your performance. > > 3.) WebDNA server that accesses the data server. > > My theory is that this could provide a realtime (or almost realtime) > inventory structure. An alternative method is to have replicated databases (which MySQL does out of the box) for the slowly changing data (i.e. the full-text lookups). Then do direct queries only for records which affect inventory (for example). This would be _much_ more scalable in the long run. John -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5748 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ John Peacock

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Grep Question - SOLVED (2003) WebCatalog plugin, FireSite and PIXO (2000) virtual virtual hosted store.... (1998) Macauth: Dates and No Scripting... (1997) WebCatalog Hosting (1996) Shopping Cart variation... (1997) Emailer (1999) More NT encyption!! (1999) [protect admin] (1997) setlineiems and UnitShip Cost (2000) ACGI processing for .html (1997) WebCat2b13MacPlugIn - more [date] problems (1997) redirect within the ErrorMessages.db (2003) Pirated WebCat? NOT... (2003) Checkboxes (1997) problems with 2 tags shakur (1997) Cookies not setting on IE (2002) Quit revisited (1997) Fixed: 2cd pair of eyes please. (2003) Displaying photo attached to first record (1997)