Dating Website Support Forum - Webscribble

Hi guys,

I just moved my site to a new server and all of a sudden my database is way too slow. Actually, queries like "Members who viewed you", "Members who IMed you" etc. take so long that I received an email from my host to check my script. I wonder what might be causing this?

Thaks

Jubiso,

Once your database becomes large in webdate you will need to make sure that it is indexed properly.

There is a script that can be run that will index your database tables.

after indexing your database you will see a great increase in query speeds.

if you need the file that indexes the database send me a PM

Paul

blacksdadating.com it takes at least 5 or 6 minutes to get the index loaded. HELP. was not like that before... I only have about 10 customers
Help..How do I get the apps and mods.

if you are having database issues and have not run the indexing script yet

download this file

upload to your home directory

and open it in your browser

this is for version 3.0

I believe it also indexes version 2.0

after uploading open it

RUN THIS FILE ONLY ONCE AND DELETE WHEN DONE! IMPORTANT!

http://yoursitenamehere.com/db_index3.php



Paul

This does not work on 2.0

mike send me ftp and access to your phpmyadmin in a private message and I will have a look at your database

Paul

I got """"Could not connect to mysql"""" ...why?

for 2.0 you will need to change the first line from .php to .pml