Speeding up select queries on table with 3million rows.

FAQ

Profile

Speeding up select queries on table with 3million rows.

Database Help (Home) -> mySQL

Next: Client Access ODBC driver problem

Author

Message

Paul

External

Since: Feb 08, 2005
Posts: 2

(Msg. 1) Posted: Tue Feb 08, 2005 1:56 pm Post subject: Re: Speeding up select queries on table with 3million rows. [Login to view extended thread Info.] Archived from groups: mailing>database>mysql (more info?)

On 1 Feb 2005 13:20:31 -0800, wrote: >Thank you for the suggestions. The queries are taking around 2 secs >after I created separate indexes and changed varchars to chars. How >does google do it in milliseconds?? Is it just super hardware? > >What happens when there are both multicolumn and single column indexes? >Which one does MySQL use? > >I'd appreciate if anyone could suggest a good introductory book on >these database topics. I find this fascinating. > >Yahya "MySQL" by Paul DuBois covers a lot of these topics pretty well. >> Stay informed about: Speeding up select queries on table with 3million rows.

Display posts from previous:

Related Topics:

Correcting queries - In Oracle there is a way to correct any mistakes in a query, by simply entering the edit command. And from there, a text editor is opened, to allow the corrections to be made to the query. This eleminates having to retype the whole query. Is this..

Dropped Connections, Abandoned Queries - Can anyone point to documentation, or pass along some insight on how MySQL handles dropped connections and abandoned queries? How does MySQL cope with people/processes that log on and then neglect/fail to logout properly? Clearly multiple logons to the...

Select more than just * - Is it possible to run a query like this: SELECT *, DATEDIFF(CURDATE(), `updated`) AS `daysSinceUpdate` FROM `Admin` Or should I let PHP calculate the days since update?

select with regexp - i have a column "path" with values eg. +---------------+ | path | +---------------+ |/path/path/path| +---------------+ |/path/path | +---------------+ |/path | +---------------+ i want to select the row where there are ...

Random select - Hi, When I do a select with a limit I get always the same records. Usually this is the desidered effect. But now I want to do a random select. So every time I do a select I should get a different set of results. What is the best way to achieve this..

	Database Help (Home) -> mySQL	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum