« How do I delete a column from a table? | Main | How do I delete the nth row from a table? »

I know SQL and don’t care to learn q. Can I still get my work done while benefiting from kdb’s speed?

Yes and no. q supports SQL out of the box. In many cases, you will see an improvement in performance compared to a similar traditional RDBMS. However, q does not optimize your queries for you, so some queries may actually take more time.

James Gosling stated that he purposely made Java syntax C-like to facilitate the adoption of the JVM platform. q's query language was similarly designed to resemble SQL. Begin with what you know, and incrementally refine your queries using q-specific features to get the best performance possible.

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
All HTML will be escaped. Textile formatting is allowed.