My Site Speed is fixed!

[Sai_dallas]

Hi All,

Thanks to all who tried to help me the speed of my Site.

That issue is resolved now.

You may check and see for your self.

http://www.RealtyLinkDirectory.com

Thanks
Sai

[Greg]

Congrats.
What did you do?
You may also want to increase the height of your header. (Messed up in FireFox)
Try:

div.header
{
	height: 90px;
	background-color: #FFF;
}

[Sai_dallas]

I never used FireFox before.

Installed once but some how did not like it not sure which version it was.

Since you mentioned couple of times, I went ahead and got FrieFox.

Increased the header Height as well.

Checked the site in Firefox and it looks good now.

Thanks
Sai

It looks like you have pretty changes in directory design.
How did you solve your problem with site's speed, nevertheless? Was it related with our script?

[Sai_dallas]

The issue is solved by adding an Index.

MySQL operating in a limited memory environment need more indexes.

Any field that is used in query needs to be indexed.

I use Oracle at work and did not expect 6000 rows to be matter for a database.

In the absence of an Index Database use full table scan.

For Oracle unless the table has over 200,000 records it is not an issue.
Apparently for MySQL it does matter.

I still think the load time for the first page is still little high; will let you know if I could figure out the reason.

Thanks
Sai

[scanreg]

I've seen other scripts, too, speed up by adding index fields - sometimes dramatically.

[jschodde]

Originally Posted by Sai_dallas

The issue is solved by adding an Index.

Can you specify which tables you added the indexes to? I was questioning this last week in a thread (which I can no longer access) and I think it was Simon that said MySql doesn't need extra indexes...

Any ways, I was thinking about adding new indexes and would appreciate knowing what you did because I anticipate my directory getting quite large.