UTF8 and Speedups

Archival storage for Announcements. Peruse old Announcements here!

Moderators: Community Team, Global Moderators, Media Team

Forum rules
Please read the Community Guidelines before posting.

UTF8 and Speedups

Postby lackattack on Thu Oct 29, 2009 6:51 am

UTF-8

I've converted the website and database over to the UTF-8 character encoding. This means that we can now have game chat in all languages from japanese to hebrew! It is a first step towards translating Conquer Club in different languages, and other website improvements.

Speedups

I also defragmented the database and fixed a few bottlenecks...

  • The view entire log link is now 5x faster, which is nice because some longer games took a while to load.
  • Each hour, when the website cleans up expired game invites, several games would lock up for about 3 minutes or more. This has been eliminated.
  • Game finder searches for specific maps are now much faster.

I'll now start working on these issues:
  • Each night several games lock up due to an email issue
  • The game interface needs to be more fault tolerant so that it doesn't freeze when the server has a "hiccup".
User avatar
Private 1st Class lackattack
Retired Administrator
 
Posts: 6112
Joined: Sun Jan 01, 2006 10:34 pm
Location: Montreal, QC
Medals: 9
Standard Achievement (1) Doubles Achievement (1) Triples Achievement (1) Freestyle Achievement (1) Speed Achievement (1)
Teammate Achievement (1) Cross-Map Achievement (1) General Achievement (2)

Re: UTF8 and Speedups

Postby colton24 on Thu Oct 29, 2009 6:55 am

=D> =D> =D> =D> Nice updates!
Highest Rank: Lt | Highest Score: 1641
Mr. Squirrel wrote:
pmchugh wrote:BUMP- one more fool needed :mrgreen:

One fool reporting for duty!
User avatar
Private 1st Class colton24
 
Posts: 1923
Joined: Mon Jun 22, 2009 8:27 am
Location: Alabama
Medals: 22
Standard Achievement (2) Doubles Achievement (1) Triples Achievement (1) Terminator Achievement (1) Assassin Achievement (1)
Manual Troops Achievement (1) Freestyle Achievement (1) Fog of War Achievement (2) Speed Achievement (2) Teammate Achievement (1)
Cross-Map Achievement (1) Ratings Achievement (2) General Achievement (2) Training Achievement (1) Tournament Contribution (3)

Re: UTF8 and Speedups

Postby Dako on Thu Oct 29, 2009 6:58 am

Great thing about UTF-8. It works! Cyrillic characters in the chat! Woohoo! =D>
Image
User avatar
Colonel Dako
 
Posts: 3946
Joined: Sun Aug 26, 2007 9:07 am
Location: St. Petersburg, Russia
Medals: 116
Standard Achievement (3) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (1) Manual Troops Achievement (2) Freestyle Achievement (2) Polymorphic Achievement (1) Nuclear Spoils Achievement (2)
Fog of War Achievement (3) Trench Warfare Achievement (1) Speed Achievement (1) Teammate Achievement (2) Random Map Achievement (2)
Cross-Map Achievement (3) Battle Royale Achievement (1) Ratings Achievement (3) Tournament Achievement (14) General Achievement (24)
Clan Achievement (20) General Contribution (20)

Re: UTF8 and Speedups

Postby Duality. on Thu Oct 29, 2009 6:58 am

Thanks! :)
User avatar
Sergeant 1st Class Duality.
 
Posts: 331
Joined: Sat Oct 10, 2009 4:38 pm
Medals: 26
Standard Achievement (3) Doubles Achievement (2) Triples Achievement (1) Quadruples Achievement (1) Assassin Achievement (2)
Manual Troops Achievement (2) Freestyle Achievement (3) Fog of War Achievement (3) Speed Achievement (3) Cross-Map Achievement (3)
Ratings Achievement (3)

Re: UTF8 and Speedups

Postby asuman1179 on Thu Oct 29, 2009 8:45 am

That is great.
Cadet asuman1179
 
Posts: 31
Joined: Tue Sep 08, 2009 8:18 pm
Location: Denver, CO
Medals: 16
Standard Achievement (2) Doubles Achievement (2) Triples Achievement (1) Quadruples Achievement (1) Terminator Achievement (1)
Manual Troops Achievement (1) Freestyle Achievement (1) Nuclear Spoils Achievement (1) Fog of War Achievement (2) Teammate Achievement (1)
Cross-Map Achievement (1) Ratings Achievement (2)

Re: UTF8 and Speedups

Postby psychobkrazy on Thu Oct 29, 2009 9:47 am

Thank you! :D =D>
Image
PM me with "Tournament Invite List" in the Subject to get on my Invite List.
Highest Rank: 3070 Image Brigadier - #70 (page 1) - 61% Won - 01/02/2011
The Sigatar Lounge
User avatar
Captain psychobkrazy
 
Posts: 815
Joined: Wed Jul 30, 2008 8:03 am
Location: near Detroit
Medals: 109
Standard Achievement (4) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (4) Terminator Achievement (2)
Assassin Achievement (2) Manual Troops Achievement (4) Freestyle Achievement (3) Nuclear Spoils Achievement (3) Fog of War Achievement (4)
Trench Warfare Achievement (3) Speed Achievement (3) Teammate Achievement (3) Random Map Achievement (2) Cross-Map Achievement (4)
Beta Map Achievement (1) Ratings Achievement (4) Tournament Achievement (6) General Achievement (5) Clan Achievement (14)
Tournament Contribution (31) General Contribution (1)

Re: UTF8 and Speedups

Postby laddida on Thu Oct 29, 2009 10:06 am

still getting alot of slow response time, sometimes it will respond right away or something it will take 30seconds its off and on but mostly on so far. I take it that the fixings are still in the process though.
Image
User avatar
General laddida
 
Posts: 508
Joined: Mon Nov 19, 2007 11:25 am
Medals: 31
Standard Achievement (1) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (2) Freestyle Achievement (1)
Fog of War Achievement (2) Speed Achievement (2) Cross-Map Achievement (3) Ratings Achievement (3) Tournament Achievement (4)
Clan Achievement (7)

Re: UTF8 and Speedups

Postby jammyjames on Thu Oct 29, 2009 10:12 am

how come the scoreboard has changed too lack? there appears to be every user, both banned and not playing on the board, im down about 100 places, lol
Image
Sergeant 1st Class jammyjames
 
Posts: 1362
Joined: Tue May 06, 2008 3:17 am
Medals: 52
Standard Achievement (4) Doubles Achievement (3) Triples Achievement (2) Quadruples Achievement (2) Terminator Achievement (2)
Assassin Achievement (3) Manual Troops Achievement (3) Freestyle Achievement (4) Polymorphic Achievement (1) Nuclear Spoils Achievement (2)
Fog of War Achievement (4) Trench Warfare Achievement (1) Speed Achievement (3) Teammate Achievement (2) Random Map Achievement (2)
Cross-Map Achievement (3) Ratings Achievement (4) Tournament Achievement (2) General Achievement (1) Clan Achievement (4)

Re: UTF8 and Speedups

Postby lackattack on Thu Oct 29, 2009 10:19 am

I fixed the scoreboard.

Unfortunately the database server is not entirely happy with these changes yet...
User avatar
Private 1st Class lackattack
Retired Administrator
 
Posts: 6112
Joined: Sun Jan 01, 2006 10:34 pm
Location: Montreal, QC
Medals: 9
Standard Achievement (1) Doubles Achievement (1) Triples Achievement (1) Freestyle Achievement (1) Speed Achievement (1)
Teammate Achievement (1) Cross-Map Achievement (1) General Achievement (2)

Re: UTF8 and Speedups

Postby laddida on Thu Oct 29, 2009 10:21 am

lackattack wrote:I fixed the scoreboard.

Unfortunately the database server is not entirely happy with these changes yet...



database servers think and have feelings? and will heal itself? :lol: sounds like an interesting server
Image
User avatar
General laddida
 
Posts: 508
Joined: Mon Nov 19, 2007 11:25 am
Medals: 31
Standard Achievement (1) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (2) Freestyle Achievement (1)
Fog of War Achievement (2) Speed Achievement (2) Cross-Map Achievement (3) Ratings Achievement (3) Tournament Achievement (4)
Clan Achievement (7)

Re: UTF8 and Speedups

Postby jammyjames on Thu Oct 29, 2009 10:32 am

laddida wrote:
lackattack wrote:I fixed the scoreboard.

Unfortunately the database server is not entirely happy with these changes yet...



database servers think and have feelings? and will heal itself? :lol: sounds like an interesting server


:lol: :lol: :lol:

thanks for the scoreboard fix lack...
Image
Sergeant 1st Class jammyjames
 
Posts: 1362
Joined: Tue May 06, 2008 3:17 am
Medals: 52
Standard Achievement (4) Doubles Achievement (3) Triples Achievement (2) Quadruples Achievement (2) Terminator Achievement (2)
Assassin Achievement (3) Manual Troops Achievement (3) Freestyle Achievement (4) Polymorphic Achievement (1) Nuclear Spoils Achievement (2)
Fog of War Achievement (4) Trench Warfare Achievement (1) Speed Achievement (3) Teammate Achievement (2) Random Map Achievement (2)
Cross-Map Achievement (3) Ratings Achievement (4) Tournament Achievement (2) General Achievement (1) Clan Achievement (4)

Re: UTF8 and Speedups

Postby lackattack on Thu Oct 29, 2009 10:42 am

Turns out it was the scoreboard bug that was slowing things down! I guess even the database server doesn't want to see maxatstuy as Conqueror :lol:

I forgot to mention this fix:

  • Game finder searches for specific maps are now much faster.
User avatar
Private 1st Class lackattack
Retired Administrator
 
Posts: 6112
Joined: Sun Jan 01, 2006 10:34 pm
Location: Montreal, QC
Medals: 9
Standard Achievement (1) Doubles Achievement (1) Triples Achievement (1) Freestyle Achievement (1) Speed Achievement (1)
Teammate Achievement (1) Cross-Map Achievement (1) General Achievement (2)

Re: UTF8 and Speedups

Postby jammyjames on Thu Oct 29, 2009 10:43 am

lackattack wrote:Turns out it was the scoreboard bug that was slowing things down! I guess even the database server doesn't want to see maxatstuy as Conqueror :lol:

I forgot to mention this fix:

  • Game finder searches for specific maps are now much faster.



once again thanks, lol

haha lack makes jokes :lol: :lol: way to make my day with that 1
Image
Sergeant 1st Class jammyjames
 
Posts: 1362
Joined: Tue May 06, 2008 3:17 am
Medals: 52
Standard Achievement (4) Doubles Achievement (3) Triples Achievement (2) Quadruples Achievement (2) Terminator Achievement (2)
Assassin Achievement (3) Manual Troops Achievement (3) Freestyle Achievement (4) Polymorphic Achievement (1) Nuclear Spoils Achievement (2)
Fog of War Achievement (4) Trench Warfare Achievement (1) Speed Achievement (3) Teammate Achievement (2) Random Map Achievement (2)
Cross-Map Achievement (3) Ratings Achievement (4) Tournament Achievement (2) General Achievement (1) Clan Achievement (4)

Re: UTF8 and Speedups

Postby pimphawks70 on Thu Oct 29, 2009 10:47 am

Thanks lack
Image
User avatar
Brigadier pimphawks70
 
Posts: 1106
Joined: Fri Aug 31, 2007 10:21 am
Medals: 77
Standard Achievement (4) Doubles Achievement (3) Triples Achievement (4) Quadruples Achievement (4) Terminator Achievement (3)
Assassin Achievement (3) Manual Troops Achievement (4) Freestyle Achievement (4) Nuclear Spoils Achievement (3) Fog of War Achievement (4)
Trench Warfare Achievement (1) Speed Achievement (4) Teammate Achievement (3) Random Map Achievement (1) Cross-Map Achievement (3)
Ratings Achievement (3) Tournament Achievement (21) General Achievement (3) Clan Achievement (1) General Contribution (1)

Re: UTF8 and Speedups

Postby laddida on Thu Oct 29, 2009 10:50 am

sweet
Image
User avatar
General laddida
 
Posts: 508
Joined: Mon Nov 19, 2007 11:25 am
Medals: 31
Standard Achievement (1) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (2) Freestyle Achievement (1)
Fog of War Achievement (2) Speed Achievement (2) Cross-Map Achievement (3) Ratings Achievement (3) Tournament Achievement (4)
Clan Achievement (7)

Re: UTF8 and Speedups

Postby bedub1 on Thu Oct 29, 2009 10:51 am

nice. and I have noticed in the past couple weeks that clickable maps doesn't work as well with the delays that occur...
Colonel bedub1
 
Posts: 1005
Joined: Sun Dec 31, 2006 4:41 am
Medals: 10
Standard Achievement (2) Doubles Achievement (2) Triples Achievement (1) Freestyle Achievement (1) Teammate Achievement (1)
Cross-Map Achievement (1) Ratings Achievement (1) General Contribution (1)

Re: UTF8 and Speedups

Postby AndyDufresne on Thu Oct 29, 2009 12:12 pm

Good good good. I hope to see some remarkable improvement in speed now! ;)


--Andy
User avatar
Corporal 1st Class AndyDufresne
Retired Administrator
 
Posts: 25441
Joined: Fri Mar 03, 2006 8:22 pm
Location: A Banana Palm in Zihuatanejo
Medals: 20
Standard Achievement (2) Doubles Achievement (1) Triples Achievement (1) Quadruples Achievement (1) Terminator Achievement (1)
Freestyle Achievement (1) Fog of War Achievement (1) Trench Warfare Achievement (1) Speed Achievement (1) Teammate Achievement (1)
Cross-Map Achievement (3) General Achievement (4) General Contribution (2)

Re: UTF8 and Speedups

Postby targetman377 on Thu Oct 29, 2009 12:39 pm

thanks lack i have noticed it great job!!!! =D> =D> =D>

*throws a a banana bunch at lack for his good job*

*wonders why andy did not do it* :-s
VOTE AUTO/TARGET in 12
User avatar
Corporal 1st Class targetman377
 
Posts: 1384
Joined: Wed Jan 17, 2007 9:52 pm
Medals: 23
Standard Achievement (3) Doubles Achievement (2) Triples Achievement (1) Quadruples Achievement (1) Freestyle Achievement (2)
Nuclear Spoils Achievement (1) Fog of War Achievement (2) Speed Achievement (1) Teammate Achievement (1) Random Map Achievement (1)
Cross-Map Achievement (2) Ratings Achievement (4) General Achievement (2)

Re: UTF8 and Speedups

Postby clapper011 on Thu Oct 29, 2009 12:42 pm

great work lack! now get back to work! :P :mrgreen:
User avatar
Corporal 1st Class clapper011
 
Posts: 7883
Joined: Mon Feb 20, 2006 10:25 am
Location: Ontario, Canada
Medals: 87
Standard Achievement (4) Doubles Achievement (4) Triples Achievement (4) Quadruples Achievement (4) Terminator Achievement (3)
Assassin Achievement (3) Manual Troops Achievement (3) Freestyle Achievement (4) Polymorphic Achievement (1) Nuclear Spoils Achievement (3)
Fog of War Achievement (4) Trench Warfare Achievement (1) Speed Achievement (4) Teammate Achievement (4) Random Map Achievement (2)
Cross-Map Achievement (3) Ratings Achievement (3) Tournament Achievement (2) General Achievement (7) Clan Achievement (7)
Tournament Contribution (3) General Contribution (14)

Re: UTF8 and Speedups

Postby soundman on Thu Oct 29, 2009 2:03 pm

Awesome lack! :D
User avatar
Lieutenant soundman
 
Posts: 450
Joined: Mon Feb 04, 2008 12:36 pm
Location: Washington
Medals: 49
Standard Achievement (2) Doubles Achievement (3) Triples Achievement (2) Quadruples Achievement (3) Terminator Achievement (1)
Assassin Achievement (1) Manual Troops Achievement (1) Freestyle Achievement (1) Nuclear Spoils Achievement (1) Fog of War Achievement (3)
Speed Achievement (1) Teammate Achievement (1) Random Map Achievement (1) Cross-Map Achievement (3) Ratings Achievement (3)
Tournament Achievement (1) General Achievement (8) Clan Achievement (12) Tournament Contribution (1)

Re: UTF8 and Speedups

Postby 72o on Thu Oct 29, 2009 2:03 pm

targetman377 wrote:thanks lack i have noticed it great job!!!! =D> =D> =D>

*throws a a banana bunch at lack for his good job*

*wonders why andy did not do it* :-s


wut?

<envisions a turtle trying to eat a banana>
Image
Sergeant 72o
 
Posts: 1014
Joined: Tue Jun 09, 2009 9:04 am
Medals: 34
Standard Achievement (3) Doubles Achievement (2) Triples Achievement (1) Quadruples Achievement (2) Terminator Achievement (2)
Assassin Achievement (1) Manual Troops Achievement (1) Nuclear Spoils Achievement (1) Fog of War Achievement (2) Speed Achievement (2)
Teammate Achievement (1) Random Map Achievement (1) Cross-Map Achievement (3) Ratings Achievement (3) Tournament Achievement (2)
General Achievement (2) Clan Achievement (5)

Re: UTF8 and Speedups

Postby Gilligan on Thu Oct 29, 2009 2:16 pm

I think that log-downloading feature affected the Battle Royale... I can't get into it without Firefox freezing on me. It hasn't happened before this update.
Image
User avatar
Major Gilligan
Cartography Assistant
Cartography Assistant
 
Posts: 12717
Joined: Thu May 11, 2006 4:59 pm
Location: Providence, RI
Medals: 200
Monthly Leader Silver (1) Monthly Leader Bronze (1) Most Improved Silver (1) Standard Achievement (4) Doubles Achievement (3)
Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (3) Assassin Achievement (3) Manual Troops Achievement (3)
Freestyle Achievement (4) Polymorphic Achievement (2) Nuclear Spoils Achievement (3) Fog of War Achievement (4) Trench Warfare Achievement (3)
Speed Achievement (4) Teammate Achievement (3) Random Map Achievement (3) Cross-Map Achievement (4) Beta Map Achievement (2)
Battle Royale Achievement (3) Bot Achievement (2) Ratings Achievement (4) Tournament Achievement (30) General Achievement (31)

Re: UTF8 and Speedups

Postby the.killing.44 on Thu Oct 29, 2009 4:02 pm

谢谢!很好!
User avatar
Major the.killing.44
 
Posts: 4737
Joined: Thu Oct 23, 2008 7:43 pm
Location: now tell me what got two gums and knows how to spit rhymes
Medals: 47
Standard Achievement (3) Doubles Achievement (3) Triples Achievement (2) Quadruples Achievement (2) Terminator Achievement (1)
Assassin Achievement (2) Manual Troops Achievement (2) Freestyle Achievement (3) Nuclear Spoils Achievement (1) Fog of War Achievement (2)
Speed Achievement (3) Cross-Map Achievement (3) Ratings Achievement (3) Tournament Achievement (3) General Achievement (3)
Clan Achievement (3) Map Contribution (2) Tournament Contribution (2) General Contribution (4)

Re: UTF8 and Speedups

Postby galix on Thu Oct 29, 2009 5:28 pm

GREAT WORK - keep it up.......
Cadet galix
 
Posts: 53
Joined: Thu Aug 21, 2008 12:23 pm
Location: Fort Lauderdale, Fl.
Medals: 15
Standard Achievement (2) Doubles Achievement (1) Triples Achievement (2) Quadruples Achievement (1) Terminator Achievement (1)
Manual Troops Achievement (1) Freestyle Achievement (1) Fog of War Achievement (1) Teammate Achievement (2) Cross-Map Achievement (1)
Ratings Achievement (1) Tournament Achievement (1)

Re: UTF8 and Speedups

Postby Wickedosity on Thu Oct 29, 2009 7:54 pm

Great job!
Image
User avatar
Major Wickedosity
 
Posts: 16
Joined: Fri Oct 17, 2008 5:20 pm
Location: California
Medals: 30
Standard Achievement (2) Doubles Achievement (2) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (1)
Assassin Achievement (2) Manual Troops Achievement (1) Freestyle Achievement (1) Nuclear Spoils Achievement (1) Fog of War Achievement (3)
Speed Achievement (1) Cross-Map Achievement (3) Ratings Achievement (3) General Achievement (1) Clan Achievement (3)

Next

Return to Announcement Archives

Who is online

Users browsing this forum: No registered users

cron
Login