Autocomplete slow on Heroku - Heroku Community

The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Message from discussion Autocomplete slow on Heroku
Received-SPF: neutral (google.com: 74.125.92.24 is neither permitted nor denied by best guess record for domain of n...@quaran.to) client-ip=74.125.92.24;
MIME-Version: 1.0
In-Reply-To: <a322247a-1b5d-4187-b6d5-dabf8adaee52@21g2000yqj.googlegroups.com>
References: <530d48e51001252020j1bf765bau11e3ed0da78215b0@mail.gmail.com>
	 <a322247a-1b5d-4187-b6d5-dabf8adaee52@21g2000yqj.googlegroups.com>
Date: Tue, 26 Jan 2010 10:23:00 -0500
Message-ID: <e81d4f0a1001260723m3718f0dal22a20ae3340437ce@mail.gmail.com>
Subject: Re: Autocomplete slow on Heroku
From: Nick Quaranto <n...@quaran.to>
To: heroku@googlegroups.com
Content-Type: multipart/alternative; boundary=00235429d8fc7dfb38047e12dcb7

--00235429d8fc7dfb38047e12dcb7
Content-Type: text/plain; charset=ISO-8859-1

Are you using MySQL to develop locally instead of Postgres? MySQL considers
LIKE case insensitive, you need to use ILIKE on postgresql to get the same
behavior.

-Nick

On Tue, Jan 26, 2010 at 10:20 AM, Sunny Beach <sunnybeach1...@gmail.com>wrote:

> I have narrowed down the problem to capitalization. If the query
> string matches up (exactly) then all is well.
>
> BAD:
> http://content-tracker.heroku.com/program_names.js?q=inter
>
> GOOD: (finds three "International..." programs)
> http://content-tracker.heroku.com/program_names.js?q=Inter
>
> I have not been able to figure out how to fix this.
>
> You can see the full list of programs (only 20 currently):
> http://content-tracker.heroku.com/program_names.js
>
> Sunny
>
>
> On Jan 25, 11:20 pm, Sunny Beach <sunnybeach1...@gmail.com> wrote:
> > I have a small app that has a single Jquery Autocomplete field. It
> > seems very slow and spotty (not returning all the results it should)
> > on Heroku. It does work but not very well.
> >
> > Is this due to the differences in databases between here and Heroku?
> > The call for the autocomplete is:
> > ProgramName.find(:all, :conditions => ['name LIKE ?', "%#{params[:q]}%"])
> >
> > Is it due to a query limit (I am the only person using it at the moment).
> >
> > Any ideas?
> >
> > Thanks,
> > Sunny
>
> --
> You received this message because you are subscribed to the Google Groups
> "Heroku" group.
> To post to this group, send email to heroku@googlegroups.com.
> To unsubscribe from this group, send email to
> heroku+unsubscribe@googlegroups.com<heroku%2Bunsubscribe@googlegroups.com>
> .
> For more options, visit this group at
> http://groups.google.com/group/heroku?hl=en.
>
>

--00235429d8fc7dfb38047e12dcb7
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Are you using MySQL to develop locally instead of Postgres? MySQL considers=
 LIKE case insensitive, you need to use ILIKE on postgresql to get the same=
 behavior.<br><br>-Nick<br><br><div class=3D"gmail_quote">On Tue, Jan 26, 2=
010 at 10:20 AM, Sunny Beach <span dir=3D"ltr">&lt;<a href=3D"mailto:sunnyb=
each1...@gmail.com">sunnybeach1...@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">I have narrowed d=
own the problem to capitalization. If the query<br>
string matches up (exactly) then all is well.<br>
<br>
BAD:<br>
<a href=3D"http://content-tracker.heroku.com/program_names.js?q=3Dinter" ta=
rget=3D"_blank">http://content-tracker.heroku.com/program_names.js?q=3Dinte=
r</a><br>
<br>
GOOD: (finds three &quot;International...&quot; programs)<br>
<a href=3D"http://content-tracker.heroku.com/program_names.js?q=3DInter" ta=
rget=3D"_blank">http://content-tracker.heroku.com/program_names.js?q=3DInte=
r</a><br>
<br>
I have not been able to figure out how to fix this.<br>
<br>
You can see the full list of programs (only 20 currently):<br>
<a href=3D"http://content-tracker.heroku.com/program_names.js" target=3D"_b=
lank">http://content-tracker.heroku.com/program_names.js</a><br>
<font color=3D"#888888"><br>
Sunny<br>
</font><div><div></div><div class=3D"h5"><br>
<br>
On Jan 25, 11:20=A0pm, Sunny Beach &lt;<a href=3D"mailto:sunnybeach1...@gma=
il.com">sunnybeach1...@gmail.com</a>&gt; wrote:<br>
&gt; I have a small app that has a single Jquery Autocomplete field. It<br>
&gt; seems very slow and spotty (not returning all the results it should)<b=
r>
&gt; on Heroku. It does work but not very well.<br>
&gt;<br>
&gt; Is this due to the differences in databases between here and Heroku?<b=
r>
&gt; The call for the autocomplete is:<br>
&gt; ProgramName.find(:all, :conditions =3D&gt; [&#39;name LIKE ?&#39;, &qu=
ot;%#{params[:q]}%&quot;])<br>
&gt;<br>
&gt; Is it due to a query limit (I am the only person using it at the momen=
t).<br>
&gt;<br>
&gt; Any ideas?<br>
&gt;<br>
&gt; Thanks,<br>
&gt; Sunny<br>
<br>
--<br>
You received this message because you are subscribed to the Google Groups &=
quot;Heroku&quot; group.<br>
To post to this group, send email to <a href=3D"mailto:heroku@googlegroups.=
com">heroku@googlegroups.com</a>.<br>
To unsubscribe from this group, send email to <a href=3D"mailto:heroku%2Bun=
subscribe@googlegroups.com">heroku+unsubscribe@googlegroups.com</a>.<br>
For more options, visit this group at <a href=3D"http://groups.google.com/g=
roup/heroku?hl=3Den" target=3D"_blank">http://groups.google.com/group/herok=
u?hl=3Den</a>.<br>
<br>
</div></div></blockquote></div><br>

--00235429d8fc7dfb38047e12dcb7--
Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
Account Options
