Re: [PHP] Re: My SQL speed.

2002-08-03 Thread Ilia A.
On August 3, 2002 12:54 am, Jason Stechschulte wrote: On Sat, Aug 03, 2002 at 01:49:10AM -0300, Manuel Lemos wrote: Google has 1 billion pages and qurys in a few milliseconds... Real search engines do not use SQL databases. What do search engines use? Is there something out there that

[PHP] Re: My SQL speed.

2002-08-02 Thread Manuel Lemos
Hello, On 08/03/2002 01:36 AM, Lord Loh. wrote: I have a database of mysql with 3 million records. No query is performed in less than 10 seconds!(With Index and all that) The index will not do magic by itself, especially if it is not unique. Any way to speed this up ? Sometimes your

Re: [PHP] Re: My SQL speed.

2002-08-02 Thread Jason Stechschulte
On Sat, Aug 03, 2002 at 01:49:10AM -0300, Manuel Lemos wrote: Google has 1 billion pages and qurys in a few milliseconds... Real search engines do not use SQL databases. What do search engines use? Is there something out there that explains how they work? -- Jason Stechschulte [EMAIL

Re: [PHP] Re: My SQL speed.

2002-08-02 Thread Manuel Lemos
Hello, On 08/03/2002 01:54 AM, Jason Stechschulte wrote: On Sat, Aug 03, 2002 at 01:49:10AM -0300, Manuel Lemos wrote: Google has 1 billion pages and qurys in a few milliseconds... Real search engines do not use SQL databases. What do search engines use? Is there something out there

[PHP] Re: My SQL speed.

2002-08-02 Thread Maxim Maletsky
Lord Loh. writes: How on earth does US Social Security dept. maintain so many records ? Google has 1 billion pages and qurys in a few milliseconds... Weel, I work as a consultant on development of a similar system for Italian Government. (instead of Social Security numbers it handles all