Re: [PHP] Re: My SQL speed.

2002-08-02 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 the

[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

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 o

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 P

[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 qu