Gossamer Forum
Home : Products : DBMan SQL : Discussion :

SLOW SQL - NEED SPEED!

Quote Reply
SLOW SQL - NEED SPEED!
I have a DBMAN SQL and it is very slow. I am using permentant connection to the internet and I am currently the only user yet when I click search it sits there for 5 minutes 'thinking'. The server that holds the database is also fast. What is happening?

How can I speed up the search?

I have read through the posts and some members recommend indexing. What does this mean and how exactly do I do this?

Unsure
Quote Reply
Re: [needsupport] SLOW SQL - NEED SPEED! In reply to
I'm not sure it is DBMAN SQL that is slow. How many records do you have?

The following site has just under 14,000 big records, how long does it take for you to do searches there?

http://cus1.wiredon.net/

(try entering "test" in the central search box)

Last edited by:

RedRum: Feb 18, 2002, 1:52 AM
Quote Reply
Re: [RedRum] SLOW SQL - NEED SPEED! In reply to
It took me a few seconds to go to result page. It was fast. I have a fast connection on my computer.

I have only a few records yet it takes over a minute to load the results page!

I dont know what to do!

What are the variables and how can I make this faster?
Quote Reply
Re: [needsupport] SLOW SQL - NEED SPEED! In reply to
Do you have a URL so I can try a search?