RE: [PHP-WIN] Search expression => SQL WHERE parser?

2002-01-30 Thread Peter Illes
Thanks, Flint. I'm afraid MySQL does not have this feature :-(. OTOH what I'm looking for is simpler than that. E.g. let's turn [apple pear -cherry] into [(FLD LIKE '%apple%') AND (FLD LIKE '%pear%') AND NOT (FLD LIKE '%cherry%')] Operators: (space or +) => AND # => OR - => NOT ( ) =

[PHP-WIN] Search expression => SQL WHERE parser?

2002-01-30 Thread Peter Illes
Hi Folks, I'm looking for a parser in PHP that would turn a search expression (like google, altavista, ...) into an SQL WHERE statement, or at least an expression parser in PHP. Any idea? Our intention is to implement such a search functionality in a PHP app on a MySQL database. Thanks for any

RE: [PHP-WIN] Re: Performance tuning #2

2002-01-03 Thread Peter Illes
var-parameter version... Thanks again, Peter -Original Message- From: Alek Andreev [mailto:[EMAIL PROTECTED]] Sent: Monday, December 31, 2001 2:35 PM To: Peter Illes Subject: Re: [PHP-WIN] Re: Performance tuning #2 There are two ways to do that: Method 1: Add each new part of the result

RE: [PHP-WIN] Re: Performance tuning #2

2002-01-03 Thread Peter Illes
Alain, thanks for the link. Peter -Original Message- From: alain samoun [mailto:[EMAIL PROTECTED]] Sent: Monday, December 31, 2001 6:56 PM To: Peter Illes; [EMAIL PROTECTED] Subject: RE: [PHP-WIN] Re: Performance tuning #2 No faq, but an archive at: http://marc.theaimsgroup.com/?l=php

[PHP-WIN] Re: Performance tuning #2

2001-12-31 Thread Peter Illes
Thanks, Manuel, those are both very good ideas that we will make use of. My original problem is simpler than that, though: I'd like to pre-allocate a buffer for the string. Is this possible in PHP? This is possible in both C/C++ and Delphi (with SetLength() in Delphi). The reason for this to hav

[PHP-WIN] Re: Performance tuning #2

2001-12-30 Thread Peter Illes
avoid using external files for the accumulation, since we need some good performance and typically disk v.s. memory cannot compete (the server has enough RAM;-). "Peter Illes" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi, > >

[PHP-WIN] Performance tuning #2

2001-12-30 Thread Peter Illes
Hi, This is the second post of this problem since I did not get any answer for the first. Please, could someone out there help? Thanks in advance... I wonder if there is any performance tuning newsgroup/faq/whatever related to PHP. I searchead to no avail... Anyway, my current mind boggler is:

[PHP-WIN] String performance tuning?

2001-12-27 Thread Peter Illes
Hi, I wonder if there is any performance tuning newsgroup/faq/whatever related to PHP. I searchead to no avail... Anyway, my current mind boggler is: we are accumulating a large (~400k) XML response in a string before sending it out by adding little pieces a time (like 10-20 chars). Now this res