Thinking a little more, painful as it is to me ;-)...
Perhaps changes to the structure here might make a difference. While this
may mean a change to the application to account for this it may make
searches easier and faster.
person_table
person_id
fname
lname
ssn
other data as req'd
phone_re
Sounds like it's going awefully slow, I have a table with several million
entires, and it only takes 10-15 seconds to search through.. on a single
processor system with 1 gig of ram too..
What's the query you're using?
-Micah
On Tuesday 26 July 2005 11:24 am, [EMAIL PROTECTED] wrote:
> Ok,
Well, if you want to be as certain as you can - you're going to need to
stick to a fairly rigorous check. What you could do is export the DB
into something PHP can quickly load right in (something serialized, for
e.g.) every X minutes, and then at the end of the day run your 'rigorous
test'.
Obviously searching all the columns is creating a bottleneck, at first
glance I would consider some hashing on the values to make the search
simpler.
If home phone matches any existing home, work or alt phones.
If work phone matches any existing home, work or alt phones.
If alt phone matches an
try combining it with php
$now = date("Y-m-d H:i:s")
$sql = "select timediff($now, logouttime) from tblUserTracking";
Bastien
From: Chuck Brockman <[EMAIL PROTECTED]>
Reply-To: Chuck Brockman <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] Timediff/Subtime questions
Date: Tue,
Ok, I'm at a point where I'm just going to throw this out there and see if
anyone has any good solutions because I'm just not seeing one. Of course
there's always a better solution, but I'm too brain dead right now to see it.
So any input would be appreciated.
Also..forgive me if this is more
I've got a table that has a field logouttime which is a timestamp.
I've tried using the timediff() function in mysql and get an error:
select timediff(now(), logouttime) from tblUserTracking
Each time it returns (err). However, if I used a query such as:
select timediff('2005-07-26 22:00:00.0'
Hi all,
I have seen in the documentation ocirowcount method works only with update
statements.
which method should be used for select statement to know the number of rows
returned by a select statement.
or
how to use ocirowcount for select statements.
thanks for help
babu.
-
