Arie Nugraha napsal(a):
Hi list,
I Have a problem with my query that fetch about 22.000 records from
database, the query is like this :
SELECT SQL_CALC_FOUND_ROWS DISTINCT b.biblio_id, b.title,
a.author_name FROMbiblio AS b LEFT
JOIN biblio_author AS ba ON b.biblio_id=ba.biblio_id LEFT JOIN
ms
Arie Nugraha wrote:
Hi list,
I Have a problem with my query that fetch about 22.000 records from
database, the query is like this :
SELECT SQL_CALC_FOUND_ROWS DISTINCT b.biblio_id, b.title,
a.author_name FROMbiblio AS b LEFT
JOIN biblio_author AS ba ON b.biblio_id=ba.biblio_id LEFT JOIN
mst_au
Hi list,
I Have a problem with my query that fetch about 22.000 records from
database, the query is like this :
SELECT SQL_CALC_FOUND_ROWS DISTINCT b.biblio_id, b.title,
a.author_name FROMbiblio AS b LEFT
JOIN biblio_author AS ba ON b.biblio_id=ba.biblio_id LEFT JOIN mst_author AS
a ON ba.author
On 4/1/07, Bastien Koert <[EMAIL PROTECTED]> wrote:
I would say no, due to the overhead. What I would recommned is setting
that
up as a cron task and running it on a scheduled basis, usually when the
server is liightly loaded. Monitor the server and pick an optimal time.
This
is the same for all
monitoring
etc.
hth
Bastien
From: "Anna V" <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] Optimizing Tables
Date: Sun, 1 Apr 2007 14:35:51 -0500
Hello group,
I just have a quick question for you all. Here is it... Is it advisable to
run optimize table after ea
Hello group,
I just have a quick question for you all. Here is it... Is it advisable to
run optimize table after each deletion of a record?
Thanks in advance,
Anna Vester
At 08:44 AM 5/4/2006, blackwater dev wrote:
I just doubled the size of my MySQL db, is there a command I should run to
re-index everything or is that automatic?
Thanks!
Well, it is automatic and MySQL does not need a lot of attention.
Having said that, what table type(s) are you using, and wh
I just doubled the size of my MySQL db, is there a command I should run to
re-index everything or is that automatic?
Thanks!
till seems like a clunky solution, but it has helped somewhat.
- Original Message -
From: "Evan Morris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 26, 2003 12:01 PM
Subject: [PHP-DB] Optimizing query for public search engine
> Hi all
>
&g
Hi all
I'm using Firebird as the back-end for a web site. The search engine is
written in PHP, using bog-standard SQL queries. Here's the problem:
In order to make the results listing work well, the page needs to know how
many records match the search criteria. This is so I can
a) display '1 to
You should index everything that is used in WHERE, ORDER and GROUP
clauses. Means, if your queries do
SELECT * FROM people WHERE name='maxim';
you should add an index on name field. Also, if you do something like
this:
SELECT * FROM people WHERE name='maxim' ORDER BY surname;
then you better a
On Sun, 10 Nov 2002, Chris Payne wrote:
> Hi there everyone,
>
> How does indexing work, and does it speed up small / average size DB's of
> around 20,000 records, with 12 columns per record? (Some columns being
> paragraphs of text).
YES! 20,000 records is still a lot of records, and indexing
This varies from database to database. I would suggest reviewing the
documentation on your database type.
For review here is some information on indexing from PostgreSQL (my
database of choice):
http://www.postgresql.org/idocs/index.php?indexes.html
That should give you some ideas on how indexi
Hi there everyone,
How does indexing work, and does it speed up small / average size DB's of
around 20,000 records, with 12 columns per record? (Some columns being
paragraphs of text).
Also, do you create an index on everything or just 1 item or or or :-)
I've not looked at indexing but think i
Hello...
Try this...
$pat = array("\", "@", "*", "&", "%");
$with = (_) \\What ever you want...
$car_year = str_replace ($pat, $with, stripslashes($car_year));
echo $car_year;
This would work with ONE VARIABLE...
I suppose maybe you could make the
Variables($car_type,$car_mod
I have a script that prevents invalid characters from being passed from a
html form to a mysql database using php and I am wondering if there is a way
to condense it so instead of declaring the ereg_replace for each field in
the html form, to simply use one function to remove invalid characters an
@yahoo.com |
+-+---++
and it seemed to mail faster than if it was in random order.
hope that helps
-b
// -Original Message-
// From: olinux [mailto:[EMAIL PROTECTED]]
// Sent: Tuesday, 15 January 2002 10:57 AM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] Optimizing mail()
//
//
//
Just came across this post and wondered if anyone has
done this - if so can you share some code?
The idea is to order emails by the mailservers
Would you just order the emails by domain name? [that
would group all aol.com, msn.com, yahoo.com emails]
http://www.faqts.com/knowledge_base/view.phtm
18 matches
Mail list logo
