RE: My sql database and faster queries

[VVM Ravikumar Sarma Chengalvala]

Hi,
THe maximum number of table joins I ned is not more
than three.Most of the search criteria is based on
Unique or Primary keys and hence I did not opt for
indexing.I am using the default myISAM table types of
mysql and mysql C_API.
Previously someone suggested using C_API functions
over joins will make the queries run faster.The
database may have to search for all the queries from
about 100000 rows in each table.

Regards,
Ravi
--- Brandon Lewis <[EMAIL PROTECTED]> wrote: > The
all horrible answer "depends".  The database is
> just that, a database,
> and it is intended to be used to store and retrieve
> relational data. The
> structure of your tables, and indexes will play a
> big role, also
> table\page\row locking factors in greatly. I am
> sorry to say the answer is
> not black and white. Sometimes it is better to pull
> the data out and process
> it, sometimes it better to do a little of both.
> Without details I am afraid
> I can't help much.
> 
> -----Original Message-----
> From: VVM Ravikumar Sarma Chengalvala
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 06, 2001 7:45 AM
> To: [EMAIL PROTECTED]
> Subject: My sql database and faster queries
> 
> Hi,
> I wonder to know which of the following is better in
> performance and faster .
> 
> Using table joins for queries.
>           OR
> Multiple queries without joins using MySql C API
> 
> Regards,
> Ravi
> 
> 
> 
>
____________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.co.uk address at
> http://mail.yahoo.co.uk
> or your free @yahoo.ie address at
> http://mail.yahoo.ie
> 
>
---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list
> archive)
> 
> To request this thread, e-mail
> <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
>
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> 


____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php