View Single Post
  #8  
Old 08-19-2018, 07:01 AM
djeryv
Hill Giant
 
Join Date: Apr 2008
Posts: 234
Default

Quote:
Originally Posted by dagulus2 View Post
In terms of the SQL Data you ave to add to get the Prophetess working, does this only have to be done once or will it need updating if I add merchants or items?
Well, I did have to make tables instead of views because views cannot have primary keys set. When I moved to the table format, and set primary keys, the queries she ran were really quick.

So the SQL would need to be ran each time you add to merchants, but there is a command to drop the table if it exists and recreate it so it is a quick matter...but you would need to remember to run it.

Views would avoid this step, but the Prophetess took about 20 seconds to return results and I would rather it be instant. I think I will setup the Prophetess as a separate package for people to get, in case they don't want the other solo server stuff...of course leaving her in the solo server package as well.
Reply With Quote