Main
Index 		Search
Posts 		Who's
Online 		Log
In

Home: Discontinued/Classic Products: Article Manager 2:
mysql problem

 
 


kacrism
Novice

Mar 25, 2010, 4:36 PM

Post #1 of 4 (4496 views)
Shortcut
mysql problem Can't Post
Hi everybody!

I had changed my store method of my information. I decided to change from flat file to database mysql.

I did that in the admin panel > Database Setting > Change I gave the database's information and I watch the database on mysql with the articles, publishing rules, account and other table, but I am a litle confused because I thought that all the new information will be showed with the database information, but in fact the information is showed by the flat file.

For example, if I put a new article, the article is saved on the database correctly, but in the web page I saw a url like this http://site.com.mx/new_nota.php if you see the file new_data.php is all the information, in a flat file, and at the same time you can see this information on the database, is this a correct behavoir?

Or do I have to do something else on my publishing rules, for showing the info from database and not from the flat file?

Thanks a lot for your help!!


(This post was edited by kacrism on Mar 25, 2010, 4:37 PM)


Donna
Staff / Moderator


Mar 26, 2010, 10:27 AM

Post #2 of 4 (4419 views)
Shortcut
Re: [kacrism] mysql problem [In reply to] Can't Post
Hi there!

Changing the database storage method changes just that -- the storage. The publishing doesn't change, and Article Manager continues to create static HTML files (or php files, in your case) based on the data from the database. Nothing on the front end will change, so that's working as intended. :)

Donna

--
support@interactivetools.com


kacrism
Novice

Mar 26, 2010, 10:36 AM

Post #3 of 4 (4418 views)
Shortcut
Re: [Donna] mysql problem [In reply to] Can't Post
Could this storage method (database) improve how the server displays the web pages against the method of file flat? Saving your info on database is faster than flat files? What could be the improvement?

Thanks a lot!!!


Donna
Staff / Moderator


Mar 26, 2010, 11:54 AM

Post #4 of 4 (4416 views)
Shortcut
Re: [kacrism] mysql problem [In reply to] Can't Post
Hi there,

It won't make a difference when displaying the pages to the general public -- and non-dynamic pages are generally much faster for that, since no database parsing needs to be done. As far as your web server is concerned, you could have created the file by hand. :)

However, using MySQL will certainly speed up the back end if you have a lot of articles. Flatfile is great for up to around 1000 articles, but once you go over that threshold, it's a good idea to use MySQL instead.

Donna

--
support@interactivetools.com