Kayako logo
SupportSuite, eSupport and LiveResponse Discussion, troubleshooting and feedback related to Kayako's flagship support desk products SupportSuite, eSupport and LiveResponse.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  (#1) Old
ECSI Offline
New Member
 
Posts: 22
Join Date: May 2008
Location: Sunny Florida
What is the swcountryinfo table? - 18-05-2008, 03:21 PM

I was looking through the database stats on my newly-installed trial version, and noticed a 3MB table called swcountryinfo which it claims is 79,440 rows long. What on earth is this?
   
Reply With Quote
  (#2) Old
Jamie Edwards Offline
Operations Manager
 
Jamie Edwards's Avatar
 
Posts: 5,250
Join Date: Jan 2006
Location: United Kingdom
18-05-2008, 03:58 PM

Hi ECSI,

This contains a database of IP addresses and their corresponding geographical locations, so that when monitoring visitors you can see where they are from.


Jamie Edwards (jamie.edwards ]at[ kayako.com)
----------------------------------------------------------------
---
  • Submit bug reports here.
  • Submit support tickets via the members area.
  • Submit sales queries either via live chat or via e-mail.
  • There is no official ETA on Version 4.
  • This is not an official support forum - submit a support ticket.
   
Reply With Quote
  (#3) Old
ECSI Offline
New Member
 
Posts: 22
Join Date: May 2008
Location: Sunny Florida
18-05-2008, 04:43 PM

Gotcha. I assume that doesn't slow everything down unless you enable monitoring or something?
   
Reply With Quote
  (#4) Old
Jamie Edwards Offline
Operations Manager
 
Jamie Edwards's Avatar
 
Posts: 5,250
Join Date: Jan 2006
Location: United Kingdom
18-05-2008, 05:06 PM

No, not at all - 3MB of data in a database really is a very small amount in comparison to what MySQL is designed to handle


Jamie Edwards (jamie.edwards ]at[ kayako.com)
----------------------------------------------------------------
---
  • Submit bug reports here.
  • Submit support tickets via the members area.
  • Submit sales queries either via live chat or via e-mail.
  • There is no official ETA on Version 4.
  • This is not an official support forum - submit a support ticket.
   
Reply With Quote
Reply

Tags
swcountryinfo, table

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
corrupt swauditlogs table - what do I do? pdc_irl SupportSuite, eSupport and LiveResponse 2 23-05-2007 10:48 AM
How do I relate the tickets table to the customfields table? slarson Developers & Code 3 14-05-2007 05:11 PM
Error Creating Tables Danym SupportSuite, eSupport and LiveResponse 1 03-11-2006 10:22 AM



Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
vBulletin Skin developed by: vBStyles.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46