Date: Tue, 5 Nov 2013 19:05:58 -0800 (PST)
From: qx4096@gmail.com
To: lojban@googlegroups.com
Cc: qx4096@gmail.com
Message-Id: <57ebe6f6-1063-4a6b-ae14-f8ebdb54e58c@googlegroups.com>
In-Reply-To: <3534bf0f-d0a8-4b25-a0c8-52945fda2b4b@googlegroups.com>
References: <3534bf0f-d0a8-4b25-a0c8-52945fda2b4b@googlegroups.com>
Subject: [lojban] Re: jboselkei is back
MIME-Version: 1.0
Reply-To: lojban@googlegroups.com
Precedence: list
Mailing-list: list lojban@googlegroups.com; contact lojban+owners@googlegroups.com
Sender: lojban@googlegroups.com
Content-Type: multipart/alternative; 
	boundary="----=_Part_177_3822125.1383707158444"
X-Spam_score: -0.1
X-Spam_score_int: 0
X-Spam_bar: /

------=_Part_177_3822125.1383707158444
Content-Type: text/plain; charset=ISO-8859-1

I added some language support to the test jboselkei so that people can 
select a language when posting and searching. I don't know how to fix the 
problem of unicode characters being converted into ASCII characters. I also 
had some other problems with unicode. I had a PHP file that contained 
literal strings with unicode characters in it and saved it in unicode 
format, but when I displayed a file that included that file, the PHP code 
itself was displayed followed by a large amount of Chinese characters. I 
resaved the file in ANSI format and now names of some other languages 
appear as question marks on the jboselkei test.

I'm also wondering about the database efficiency of some of the new 
features I added to jboselkei. I have queries like "SELECT 
translations.id,translations.entry trentry,translations.postid,posts.entry 
ptentry,posts.difficulty,translations.date,posts.language FROM translations 
INNER JOIN posts ON translations.postid=posts.id WHERE 
(translations.authorid<>1) AND 1 NOT IN (SELECT userid FROM reviews WHERE 
translations.id=reviews.transid) AND (difficulty BETWEEN 1 AND 5) AND 
language='en' ORDER BY difficulty DESC LIMIT 0,25;". I don't know much 
about writing efficient queries. I hope this doesn't just go through the 
computing resources to retrieve the whole database and then return 25 with 
the highest difficulty level. Also, I don't believe there is an index on 
the difficulty field. Should there be? The difficulty field changes a lot 
so I don't know if it is a good idea to add an index on it.

I was also wondering if I should index the languages field since people 
will be searching by language. However, that field will have a small number 
of values that repeat many times. I know that Oracle SQL has a bitwise 
index which is ideal for this type of data, but I believe that MySQL does 
not.


-- 
You received this message because you are subscribed to the Google Groups "lojban" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lojban+unsubscribe@googlegroups.com.
To post to this group, send email to lojban@googlegroups.com.
Visit this group at http://groups.google.com/group/lojban.
For more options, visit https://groups.google.com/groups/opt_out.

------=_Part_177_3822125.1383707158444
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I added some language support to the test jboselkei so tha=
t people can select a language when posting and searching. I don't know how=
 to fix the problem of unicode characters being converted into ASCII charac=
ters. I also had some other problems with unicode. I had a PHP file that co=
ntained literal strings with unicode characters in it and saved it in unico=
de format, but when I displayed a file that included that file, the PHP cod=
e itself was displayed followed by a large amount of Chinese characters. I =
resaved the file in ANSI format and now names of some other languages appea=
r as question marks on the jboselkei test.<br><br>I'm also wondering about =
the database efficiency of some of the new features I added to jboselkei. I=
 have queries like "SELECT translations.id,translations.entry trentry,trans=
lations.postid,posts.entry ptentry,posts.difficulty,translations.date,posts=
.language FROM translations INNER JOIN posts ON translations.postid=3Dposts=
.id WHERE (translations.authorid&lt;&gt;1) AND 1 NOT IN (SELECT userid FROM=
 reviews WHERE translations.id=3Dreviews.transid) AND (difficulty BETWEEN 1=
 AND 5) AND language=3D'en' ORDER BY difficulty DESC LIMIT 0,25;". I don't =
know much about writing efficient queries. I hope this doesn't just go thro=
ugh the computing resources to retrieve the whole database and then return =
25 with the highest difficulty level. Also, I don't believe there is an ind=
ex on the difficulty field. Should there be? The difficulty field changes a=
 lot so I don't know if it is a good idea to add an index on it.<br><br>I w=
as also wondering if I should index the languages field since people will b=
e searching by language. However, that field will have a small number of va=
lues that repeat many times. I know that Oracle SQL has a bitwise index whi=
ch is ideal for this type of data, but I believe that MySQL does not.<br><b=
r><div dir=3D"ltr"><br></div></div>

<p></p>

-- <br />
You received this message because you are subscribed to the Google Groups &=
quot;lojban&quot; group.<br />
To unsubscribe from this group and stop receiving emails from it, send an e=
mail to lojban+unsubscribe@googlegroups.com.<br />
To post to this group, send email to lojban@googlegroups.com.<br />
Visit this group at <a href=3D"http://groups.google.com/group/lojban">http:=
//groups.google.com/group/lojban</a>.<br />
For more options, visit <a href=3D"https://groups.google.com/groups/opt_out=
">https://groups.google.com/groups/opt_out</a>.<br />

------=_Part_177_3822125.1383707158444--