Re: SQL REPLACE STATEMENT - CONSOLIDATION

From: Alvaro G. Vicario (kAlvaroNOSPAMTHANKS_at_terra.es)
Date: 10/06/04 

Date: Wed, 6 Oct 2004 22:10:46 +0200

*** Craig Keightley escribió/wrote (Wed, 6 Oct 2004 12:15:47 +0100):
> Can these lines of sql statements be consolidated into one sql statement
> (possibly using reg exps??)

You're going to kill your database server, which is the typical bottleneck
in a dynamic web site. My suggestion:

1) Write a PHP function to cleanup text
2) Get data from DB
3) Clean data with your PHP function
4) Put data back into DB 

-- 
-+ Álvaro G. Vicario - Burgos, Spain
+- http://www.demogracia.com (la web de humor barnizada para la intemperie)
++ Las dudas informáticas recibidas por correo irán directas a la papelera
-+ I'm not a free help desk, please don't e-mail me your questions
--

Relevant Pages

  • Re: DataTable - SQL delete command
    ... I would hope this functionality is implemented in a ... There's no reason to involve a database server for my ... you cannot issue SQL statements against a DataTable. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Malformed query detection
    ... We keep getting SQL statements running through the database server jobs that have cross joins, i.e. tables with no join specification. ...
    (comp.sys.ibm.as400.misc)
  • Re: DataTable - SQL delete command
    ... The guy who handles SQL statements is called database server. ... Eliyahu ... > Just wanted to verify this, and ask, why not? ...
    (microsoft.public.dotnet.framework.aspnet)