vpsdavid Posted January 18, 2007 Share Posted January 18, 2007 Hi, anyone know which tables on WHMCS's DB are ticket's content and ticket's related tables? Thanks 0 Quote Link to comment Share on other sites More sharing options...
WHMCS CEO Matt Posted January 18, 2007 WHMCS CEO Share Posted January 18, 2007 It's all the tables that start "tblticket..." Matt 0 Quote Link to comment Share on other sites More sharing options...
vpsdavid Posted January 18, 2007 Author Share Posted January 18, 2007 Thanks.. matt, what do you expect on size of tables if there are about 40,000 tickets average 1,000 words with spaces on each ticket? Any idea what will be size of tables? how can I calcualte? thanks 0 Quote Link to comment Share on other sites More sharing options...
WHMCS CEO Matt Posted January 18, 2007 WHMCS CEO Share Posted January 18, 2007 Hi David, It's likely to be pretty big. Of course, as the database grows things will get slower but you shouldn't have any major issues with that providing your server is relatively powerful. Matt 0 Quote Link to comment Share on other sites More sharing options...
vpsdavid Posted January 18, 2007 Author Share Posted January 18, 2007 Okay, I understand what you are saying. However, if you can tell me, could you tell me what will be about size of tables for tickets? What will be each ticket's size that contains 1000 words with spaces? Thank you. 0 Quote Link to comment Share on other sites More sharing options...
WHMCS CEO Matt Posted January 18, 2007 WHMCS CEO Share Posted January 18, 2007 Not sure for that exact quantity. Here's the stats from my current installation: 3293 tickets, 11342 ticket replies - total disk space used 8.4MB And it's no slower than when it was first installed. Matt 0 Quote Link to comment Share on other sites More sharing options...
vpsdavid Posted January 18, 2007 Author Share Posted January 18, 2007 so I can guess... about 90MB < 40000 tickets > 1100MB? Thank you. 0 Quote Link to comment Share on other sites More sharing options...
WHMCS CEO Matt Posted January 18, 2007 WHMCS CEO Share Posted January 18, 2007 Not sure how you worked that out. Going by the figures I posted above, 15,000 ticket posts = 9MB, so 40,000 ticket posts would equal just 24MB! All it stores is the users id, name, email and message content so you won't find a system that uses any less disk usage for storing the same amount of ticket text. Matt 0 Quote Link to comment Share on other sites More sharing options...
vpsdavid Posted January 18, 2007 Author Share Posted January 18, 2007 oh, I was calculating like 3293 tickets = 8.4MB so 40000 tickets is like between 90MB and 100MB I did it as ticket numbers, not ticket post.. am I calculating correctly? 0 Quote Link to comment Share on other sites More sharing options...
WHMCS CEO Matt Posted January 18, 2007 WHMCS CEO Share Posted January 18, 2007 Oh ok, I see. That's assuming each ticket reply has 3-4 replies, some of which are quite long with ours. But yeh, as a rough estimation that is probably about right. 0 Quote Link to comment Share on other sites More sharing options...
wrathcoder Posted June 15 Share Posted June 15 Hi, It seems a long time this question was asked, i am here to clarify something. I have seen tblticketreplies and i have found replies for tickets that have only integers in thier id's, so tickets have a varchar id, eg KEJ-529468, i just cant locate the replies, it is however shown in the whmcs interface Please guide me on this as to where or how can i find the reply in the database 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.