persistant connections and wildcard host (%)

[clarocque]

I am sure this is addressed but I can't seem to fing it (good and bad with lots of posts)

 

But what exactly is: persistant connections

 

And should I use it on a shared server if my host allows it?

 

And is there any risk to setting my mysql database to connect to wildcard hosts (%) and not just localhost?

 

Thanks

[Mark Evans]

A persistent connection is not closed after a query is run.. so you could find if your host has a low number of concurrent connections you will recieve errors.

 

Also if you allow wildcard hosts to connect to your db server then you are making it very insecure as anyone can try to connect to the db using brute force or password dictionaries.

[clarocque]

Thanks Sparky....

 

Is it preferred to run PC if my host will allow a high number or is it better to not run it?

 

Will it affect the performance of the store and if so how?

 

Also is there any other way for me to allow my clients to access my osc database besides a wildcard?

 

I have added a couple of fields in the back end of my site so I can put up messages for them and they can get the messages from me when they login to their admin.

 

The only way I was able to allow it to work was to use %

 

Otherwise I got a no access error with the ISP name in it... Is there another way to give them acces to my mysql seeing it is a shared server without the wildcard?