Best unofficial Apache Server developers community |
| |||||
| Feb 12, 2011 | |||||
|
Gabriele Favrin |
|
||||
| Tags: | |||||
|
Virtual table optimization using xBestIndex/xFilter December 19, 2010 06:21:39 AM Hi, I'm using the SQLite virtual table mechanism to create an SQL interface for a specialized relational database that doesn't speak SQL natively. Thanks to Jay Kreibich's great "Using SQLite", the implementation has been pretty straightforward so… Commented: (DERBY-4789) Always apply the bulk-insert optimization when inserting from a table functi September 7, 2010 09:11:59 AM [ https://issues.apache.org/jira/browse/DERBY-4789?page=com.atlassian.ji ra.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId= 12906807#action_12906807 ] Rick Hillegas commented on DERBY-4789: Commented: (DERBY-4789) Always apply the bulk-insert optimization when inserting from a table functi September 7, 2010 09:21:37 AM [ https://issues.apache.org/jira/browse/DERBY-4789?page=com.atlassian.ji ra.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId= 12906813#action_12906813 ] Rick Hillegas commented on DERBY-4789: Closed: (DERBY-4789) Always apply the bulk-insert optimization when inserting from a table function. January 21, 2011 01:22:12 PM [ https://issues.apache.org/jira/browse/DERBY-4789?page=com.atlassian.ji ra.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4789. Commented: (DERBY-4789) Always apply the bulk-insert optimization when inserting from a table functi September 13, 2010 07:45:17 AM [ https://issues.apache.org/jira/browse/DERBY-4789?page=com.atlassian.ji ra.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId= 12908765#action_12908765 ] Rick Hillegas commented on DERBY-4789: Updated: (DERBY-4789) Always apply the bulk-insert optimization when inserting from a table function September 12, 2010 05:18:13 PM [ https://issues.apache.org/jira/browse/DERBY-4789?page=com.atlassian.ji ra.plugin.system.issuetabpanels:all-tabpanel ] Lily Wei updated DERBY-4789: Updated: (DERBY-4789) Always apply the bulk-insert optimization when inserting from a table function September 12, 2010 05:12:16 PM [ https://issues.apache.org/jira/browse/DERBY-4789?page=com.atlassian.ji ra.plugin.system.issuetabpanels:all-tabpanel ] Lily Wei updated DERBY-4789: Updated: (DERBY-4789) Always apply the bulk-insert optimization when inserting from a table function September 7, 2010 10:28:36 AM [ https://issues.apache.org/jira/browse/DERBY-4789?page=com.atlassian.ji ra.plugin.system.issuetabpanels:all-tabpanel ] Lily Wei updated DERBY-4789: Updated: (DERBY-4789) Always apply the bulk-insert optimization when inserting from a table function September 8, 2010 01:33:56 PM [ https://issues.apache.org/jira/browse/DERBY-4789?page=com.atlassian.ji ra.plugin.system.issuetabpanels:all-tabpanel ] Lily Wei updated DERBY-4789: Commented: (DERBY-4789) Always apply the bulk-insert optimization when inserting from a table functi September 7, 2010 11:53:00 AM [ https://issues.apache.org/jira/browse/DERBY-4789?page=com.atlassian.ji ra.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId= 12906870#action_12906870 ] Rick Hillegas commented on DERBY-4789: Research About query optimization and Index optimization of Derby December 8, 2010 07:58:48 AM Hi all, We are going to do a research project on the query optimization and Index optimization of Apache Derby. Our group consist of four of final year students of University of Moratuwa. We did a research on the idea and expect the help from… Created: (DERBY-4883) Create a table function which turns an html table into a dbms table November 2, 2010 04:02:50 PM Create a table function which turns an html table into a dbms table Updated: (DERBY-4639) Repeatedly issuing a CREATE TABLE against a table that already exists causes D June 29, 2010 04:14:50 PM [ https://issues.apache.org/jira/browse/DERBY-4639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mike Matrigali updated DERBY-4639: Created: (DERBY-4681) Dropping a column in the table drops the views that use this table May 28, 2010 06:15:40 AM Dropping a column in the table drops the views that use this table Closed: (DERBY-2251) When I Create a table with Chinese table name , ij report IO exception. October 5, 2010 04:51:05 AM [ https://issues.apache.org/jira/browse/DERBY-2251?page=com.atlassian.ji ra.plugin.system.issuetabpanels:all-tabpanel ] Tiago R. Espinha closed DERBY-2251. Assigned: (DERBY-4639) Repeatedly issuing a CREATE TABLE against a table that already exists causes June 7, 2010 04:29:49 PM [ https://issues.apache.org/jira/browse/DERBY-4639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lily Wei reassigned DERBY-4639: Updated: (DERBY-4639) Repeatedly issuing a CREATE TABLE against a table that already exists causes D June 7, 2010 04:31:43 PM [ https://issues.apache.org/jira/browse/DERBY-4639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lily Wei updated DERBY-4639: Created: (HIVE-1480) CREATE TABLE IF NOT EXISTS get incorrect table name July 22, 2010 02:18:49 PM CREATE TABLE IF NOT EXISTS get incorrect table name Created: (HIVE-1763) drop table (or view) should issue warning if table doesn't exist November 2, 2010 03:36:55 PM drop table (or view) should issue warning if table doesn't exist Resolved: (DERBY-4479) after rename table a to b then create table a statement execute cause null po July 2, 2010 04:20:49 PM [ https://issues.apache.org/jira/browse/DERBY-4479?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mike Matrigali resolved DERBY-4479. Few questions on planning mysql table January 11, 2011 say I have a large table, 200 000 rows and I need to change/add column of enum type, would it work properly or would I experience problems? Should I… SQL optimization on multi-table queries January 10, 2011 I'm working with a large database of unemployment data built from the files available from the department of labor statistics here:… Random row query optimization in innodb table March 4, 2010 $offset = SELECT FLOOR(RAND() * COUNT(*)) FROM t_table SELECT * FROM t_table WHERE LIMIT $offset,1 This works great in myisam but i would like to… Mod_rewrite and Apache questions January 10, 2011 We have an interesting situation in relation to some help desk software that we are trying to setup. This is a web based software application that… Im making a PHP game with a map, and i have some questions January 10, 2011 Well im Making a PHP webgame with a map where players can walk on. but im very about overall performance of the game. it is a bit like this: The… PHP : parsing questions then getting the keywords February 10, 2011 I need to parse a question and then get the keywords and store them inside the database. Example: What is a void function? I can already take out… Gzip - questions about performance December 20, 2010 Firstly, I'm using Django. Django provides gzip middleware which works just fine. Nginx also provides a gzip module. Would it make more sense to… Questions about salting passwords January 12, 2011 Okay. Say for example that i set the salt for a password to "hello." Can't someone just look at the source code and discover the salt? If so, how… Two questions about mongodb console February 12, 2011 In the mongo shell: > db.thing_collection.find() { "_id" : ObjectId("4d5541bece6bff4a6d000000"), "views" : 0 } How to delete above record? {… Questions on sqlite transactions December 27, 2010 1) Is it ok to do inserts,deletes and updates in one transaction? 2) Is there a (recommended) limit to the number of writes per transaction? Caching for database questions. January 15, 2011 When we say caching like using memcahe or Redis, is this a 1:1 caching between the user and the cache or can we cache 1 item and use it for all… Some questions related to SphinxSE and RT indexes February 10, 2011 Hi. I consider using Sphinx search in one of my projects so I have a few questions related to it. When using SphinxSE and RT index, every UPDATE or… General questions about index and mysql January 28, 2011 Im trying to understand indexes better for when I use Mysql. One issue is Im still having a hard time to determine what type of index I should use… Solr questions regarding handler resolution and escaping January 9, 2011 I have a couple of questions regarding Solr usage: Certain requests can be sent to different paths (handlers?). For example, the MoreLikeThis… Questions on accessing localhost of computer outside the network January 24, 2011 I'm using wampserver. And I let my friends test the site that I made, by putting it online and giving them the ip address of my computer. The site… How to write a .htaccess redirect like stackoverflow does for its questions January 3, 2011 Hi all, I'm trying to write a .htaccess rule that would redirect someone asking for http://mysite.com/questions/123/my-question-name to… Spring3, JAXB2, Java6, NamespacePrefixMapper questions January 4, 2011 I built a simple Spring3, Hibernate3/(JPA2), RESTful service, hosted on Tomcat6, that uses JAXB2 to marshal the results. (It uses annotated pojos.)… RegEx to Extract Multiple Choice Questions February 8, 2011 Hey, I have 24 exams in a plain text file with 50 MC questions each plus a bunch of other stuff. Here is an example of what I'm trying to capture: 1… Questions about making a website like reddit digg February 11, 2011 Hey, I know this question gets asked quite a bit but I still have some lingering questions. I want to build a website similar to reddit/digg. I have… Custom IP/UDP/RTP header in windows xp (and above) + general network questions January 22, 2011 Hello, Lots of questions, I am sorry! I am doing a voice-chat (VoIP) application and I was thinking of doing a custom implementation of the… | |||||
(36 lines) Feb 12, 2011 10:23
(62 lines) Feb 12, 2011 13:39