I should say that running 7 quueries against 200MB table with ~600 000 rows
for 4 seconds looks to me as if there was no indexes and very poor database
design (i mean that CVS file is dumped into database incorrectly). Or you'r
server is Pentium 100 :)
P.S. Having myself a 1.5GB database with some
About designers who don't know PHP.
There are two kinds
1). They draw only. They usualy don't know even HTML - they just draw.
2). They know HTML and make templates. usualy these people have to know HTML
and CSS very well. And I can't imagine how they can do that without knowing
at least Smarty ta
To author:
You'r going the wrong way.
Make your page utf-8, all text on it. Set utf-8 encoding and treat all
incoming data as UTF-8. If some agent (definetly not some browser - they all
know UTF-8) doesn't understand that (that could be some "hacker" writing
it's own bot) - that's his problem. The
Hi everyone!
Generaly author of the first e-mail is right. Ofcource, crawling over the
code and getting out of it a few milliseconds off doesn't make it worth, but
you can learn what is good and what is bad and write your code correctly
from the start.
Why not to use
foreach ($data as &$value)
if
20, 2007 10:30 AM, Arvids Godjuks <[EMAIL PROTECTED]> wrote:
> > Hi!
> > I'm looking for fast HTML parser, witch can give me a tree of tags with
> > their attributes.
> > Maybe some one know a good HTML to BBCode parser, because that's exactly
> > what i
Hi!
I'm looking for fast HTML parser, witch can give me a tree of tags with
their attributes.
Maybe some one know a good HTML to BBCode parser, because that's exactly
what i need. tried looking Google, doesn't helped much, still need to make a
HTML to BBCode parser myself.
In preg_replace case need's to be done like this:
$s = preg_replace('/(\<.*\>)/Uem', 'strtolower("$1")', $s);
Don't use SQL_CALC_FOUND ROWS on simple queries, when you have to run a
simple query on one or two (with join) tables with a simple WHERE. Especialy
if tables are big. I found out that single SELECT COUNT(id) FROM table is
far more faster when query has simple WHERE conditions. I use
SQL_CALC_FOUND
8 matches
Mail list logo
