/dev/chat

12:08 AM

@FaheemMitha This is an interesting summary: en.wikipedia.org/wiki/GNU_General_Public_License#Version_3 as is this table: en.wikipedia.org/wiki/…

Braiam

12:42 AM

who was the guy trying to write autocompletition script in bash?

slm

@Braiam - did you want help finding that Q?

@Braiam - I thought it was mountainX who commented there on that Q as well...I can look if you want

Braiam

@slm nope, I remember someone was asking how to create a autocompletition script in bash or zsh

slm

@Braiam - yeah in the last week someone asked that Q

Ramesh

1:00 AM

Hi all, I have a question in MySQL select query. Currently, my SELECT statement returns 2 million rows based on WHERE clause. It is taking around 2 minutes to return the entire result set back to my PHP script.

This 2 minutes is also after applying indexing on the columns.

I was wondering, since I am using it for display in my web page, is it possible to load like 100 rows initially within seconds so that the processing can happen in back end?

Gilles

1:14 AM

0

A: Portability of file descriptor links

The /proc/PID/fd/NUM symlinks are quasi-universal on Linux, but they don't exist anywhere else (except on Cygwin which emulates them). /proc/PID/fd/NUM also exist on AIX and Solaris, but they aren't symlinks. Portably, to get information about open files, install lsof. Unices with /proc/PID/fd ...

I didn't turn up authoritative information for all variants. I no longer have access to OSX, OSF/1, AIX, HP-UX or Solaris, and not even to FreeBSD right now (I could easily remedy that one with a VM)

slm

@Braiam - this Q

1

A: Add arguments when completing a command name

This is not going to be as easy as you want. Programmable completion is not capable of replacing commands. And you have to finish (i.e. trailing whitespace) the command word before programmable completion kicks in. This means you must create an alias or function for cdd which replaces it by cd. ...

@Ramesh php.about.com/od/mysqlcommands/g/Limit_sql.htm

you can use limit to do what you want

Ramesh

@slm, thanks for the link. If I use limit, the problem is when I navigate to the second page or the third page, the results might take even more time to execute.

slm

@Ramesh - the limit would be a range so the first page would be 0,100. The next page is 101,200. etc.

Ramesh

1:31 AM

@slm, one of my lab mate suggested to use the script like below.

datatables.net/examples/data_sources/server_side.html

Most of the query processing will be carried out by the server.

It is a mix of php and ajax.

slm

@Ramesh - yes we use datatables at work as well. It's doing what i suggested, note the limit down in the code.

The UI is making smaller chunks of queries to the server through the use of the limits.

but at the expense of making more queries, typically. So this approach usually starts to stall out the DB on a heavily loaded site and the chunks of results are often times served from a cache DB such as memcached or something similar

Ramesh

Yeah, but memcached is supposed to be faster only for the executed queries right?

slm

2:01 AM

@Ramesh - correct. I wasn't implying to use memcached, only that the extra burden of having each user hit the SQL server w/ many smaller queries can become an issue later on

Ramesh

@slm, Thanks for the clarification. I will try out your suggestions :)

Transcript for