How to make Database access fast

[Vinod Bhaskar]

Hi Friends,

In my linux server (LOCAL), *accessing data through the PHP scripts from
MySQL (3.23.41)tables, it is taking more time. * Earlier it was very fast. *
Now a days
some reports it is taking more than five minuits. Earlier it use to come with
in a minuit. *What may the problem and what I have to do spead up the process.
Regards,

Vinod.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

[swdev1]

Vinod - my first guess would be to index the columns that you use in your
WHERE clauses .
The time lapse you describe sounds similar to a 'table scan'. Table scans
are bad - and are indicative of the lack of indices and are typically
occurring when the columns used in a WHERE clause of a SQL select statement
do NOT have an index.

Please check, change em, add em, whatnot - and let me know the results?
mondo regards [Bill]

--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
mySql / VFP / MS-SQL
"Vinod Bhaskar" <ma****@eth.net> wrote in message
news:bh**********@FreeBSD.csie.NCTU.edu.tw...

Hi Friends,

In my linux server (LOCAL), accessing data through the PHP scripts from
MySQL (3.23.41)tables, it is taking more time. Earlier it was very fast.
Now a days
some reports it is taking more than five minuits. Earlier it use to come with in a minuit. What may the problem and what I have to do spead up the process.

Regards,

Vinod.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

[swdev1]

Vinod - my first guess would be to index the columns that you use in your
WHERE clauses .
The time lapse you describe sounds similar to a 'table scan'. Table scans
are bad - and are indicative of the lack of indices and are typically
occurring when the columns used in a WHERE clause of a SQL select statement
do NOT have an index.

Please check, change em, add em, whatnot - and let me know the results?
mondo regards [Bill]

--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
mySql / VFP / MS-SQL
"Vinod Bhaskar" <ma****@eth.net> wrote in message
news:bh**********@FreeBSD.csie.NCTU.edu.tw...

Hi Friends,

In my linux server (LOCAL), accessing data through the PHP scripts from
MySQL (3.23.41)tables, it is taking more time. Earlier it was very fast.
Now a days
some reports it is taking more than five minuits. Earlier it use to come with in a minuit. What may the problem and what I have to do spead up the process.

Regards,

Vinod.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

[swdev1]

Vinod - my first guess would be to index the columns that you use in your
WHERE clauses .
The time lapse you describe sounds similar to a 'table scan'. Table scans
are bad - and are indicative of the lack of indices and are typically
occurring when the columns used in a WHERE clause of a SQL select statement
do NOT have an index.

Please check, change em, add em, whatnot - and let me know the results?
mondo regards [Bill]

--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
mySql / VFP / MS-SQL
"Vinod Bhaskar" <ma****@eth.net> wrote in message
news:bh**********@FreeBSD.csie.NCTU.edu.tw...

Hi Friends,

In my linux server (LOCAL), accessing data through the PHP scripts from
MySQL (3.23.41)tables, it is taking more time. Earlier it was very fast.
Now a days
some reports it is taking more than five minuits. Earlier it use to come with in a minuit. What may the problem and what I have to do spead up the process.

Regards,

Vinod.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw