loclamor

project("SpreadSheet")
 
find_package(KDE4 REQUIRED)
include(KDE4Defaults)
include_directories(${KDE4_INCLUDES} ${CMAKE_BINARY_DIR})
 
#ENABLE_TESTING(true)

set(spreadsheet_SRCS 
	main.cpp

loclamor

const QString SpreadSheetMainWindow::locationFromIndex(int row, int column){
    QString s;
    column++;
    do {
        column--;
        s = QString('A' + (column % 26)) + s;

        column = column / 26 ;

    } while(column > 0);

loclamor

[build] (master) $ gdb tomahawk
GNU gdb (Ubuntu/Linaro 7.4-2012.04-0ubuntu2.1) 7.4-2012.04
Copyright (C) 2012 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "i686-linux-gnu".
For bug reporting instructions, please see:
<http://bugs.launchpad.net/gdb-linaro/>...

loclamor

virtual Tomahawk::PlayableProxyModelPlaylistInterface::~PlayableProxyModelPlaylistInterface() 
virtual Tomahawk::PlayableProxyModelPlaylistInterface::~PlayableProxyModelPlaylistInterface() 
m_trackView: TrackView(0xa850af8) 0 
virtual TrackView::~TrackView() "with empty guid" 
virtual Tomahawk::PlayableProxyModelPlaylistInterface::~PlayableProxyModelPlaylistInterface() 
virtual void TrackView::setGuid(const QString&) Setting guid on header "playlistmodel/53778a9e-4cc1-481f-a23a-d10a20347f4c" for a view with 12 columns 
virtual void TrackView::setGuid(const QString&) Restoring shuffle & random mode settings for guid "playlistmodel/53778a9e-4cc1-481f-a23a-d10a20347f4c" 
void AudioControls::onControlStateChanged() 
void AudioControls::onControlStateChanged() 
virtual void TrackView::resizeEvent(QResizeEvent*) 906 

loclamor

INFO  - 2013-07-02 14:07:13.905; org.apache.solr.update.processor.LogUpdateProcessor; [collection1] webapp=/solr path=/update params={wt=javabin&version=2} {} 0 1
ERROR - 2013-07-02 14:07:13.906; org.apache.solr.common.SolrException; org.apache.solr.common.SolrException: com.spatial4j.core.exception.InvalidShapeException: Unable to read: POLYGON((118.47202905498784 -28.091585327722534, 126.27524720157743 -62.37012085331162, 127.91904741006499 -61.87012085331162, 120.1158292634754 -27.591585327722534, 118.47202905498784 -28.091585327722534))
  at org.apache.solr.schema.AbstractSpatialFieldType.parseShape(AbstractSpatialFieldType.java:144)
	at org.apache.solr.schema.AbstractSpatialFieldType.createFields(AbstractSpatialFieldType.java:118)
	at org.apache.solr.update.DocumentBuilder.addField(DocumentBuilder.java:186)
	at org.apache.solr.update.DocumentBuilder.toDocument(DocumentBuilder.java:257)
	at org.apache.solr.update.AddUpdateCommand.getLuceneDocument(AddUpdateCommand.java:73)
	at org.apache.solr.update.Direc

loclamor

select p.idprel,
e.lespcm,
s.idstation
from opt_prelevement p
INNER JOIN espece e ON (p.cesp = e.cesp)
INNER JOIN opt_station s ON (p.idstation = s.idstation)
order by idprel limit 10 offset 289900

=> 49.394ms

loclamor

2013-07-24 16:44:28,430 [http-bio-8080-exec-3] INFO  com.telespazio.eocat.config.SyracuseToMongo - migration of 10000 prelevements from E550251111 ( 429900 )
2013-07-24 16:44:31,093 [http-bio-8080-exec-3] INFO  com.telespazio.eocat.config.SyracuseToMongo -   1000 prelevements inserted in mongoDB.
2013-07-24 16:44:33,431 [http-bio-8080-exec-3] INFO  com.telespazio.eocat.config.SyracuseToMongo - 	1000 prelevements inserted in mongoDB.
2013-07-24 16:44:35,673 [http-bio-8080-exec-3] INFO  com.telespazio.eocat.config.SyracuseToMongo - 	1000 prelevements inserted in mongoDB.
2013-07-24 16:44:37,857 [http-bio-8080-exec-3] INFO  com.telespazio.eocat.config.SyracuseToMongo - 	1000 prelevements inserted in mongoDB.
2013-07-24 16:44:40,037 [http-bio-8080-exec-3] INFO  com.telespazio.eocat.config.SyracuseToMongo - 	1000 prelevements inserted in mongoDB.
2013-07-24 16:44:42,234 [http-bio-8080-exec-3] INFO  com.telespazio.eocat.config.SyracuseToMongo - 	1000 prelevements inserted in mongoDB.
2013-07-24 16:44:44,355 [http-

loclamor

2013-07-24 17:19:31,585 [http-bio-8080-exec-3] INFO  com.telespazio.eocat.config.SyracuseToMongo - Starting migrating data...
2013-07-24 17:19:31,585 [http-bio-8080-exec-3] INFO  com.telespazio.eocat.config.SyracuseToMongo - Initializing...
2013-07-24 17:19:31,822 [http-bio-8080-exec-3] INFO  com.telespazio.eocat.config.SyracuseToMongo - lastId is P0025201101191100, limit is 10000, nbInsert is 1000
2013-07-24 17:19:31,829 [http-bio-8080-exec-3] INFO  com.telespazio.eocat.config.SyracuseToMongo - migration of 10000 prelevements from P0025201101191100 ( 1119900 )
2013-07-24 17:19:34,891 [http-bio-8080-exec-3] INFO  com.telespazio.eocat.config.SyracuseToMongo -   1000 prelevements inserted in mongoDB.
2013-07-24 17:19:36,109 [http-bio-8080-exec-3] INFO  com.telespazio.eocat.config.SyracuseToMongo - 	1000 prelevements inserted in mongoDB.
2013-07-24 17:19:37,353 [http-bio-8080-exec-3] INFO  com.telespazio.eocat.config.SyracuseToMongo - 	1000 prelevements inserted in mongoDB.
2013-07-24 17:19:38,547 [http-bio-8080

loclamor

stations :
{
  idstation : <idstation>,
	loc : [<long>, <lat>],
	prelevements : [
		{
			idprel : <idprel>,
			debprel : <date debut prel>,
			finprel : <date fin prel>,
			espece : <espece>, //type prel

loclamor

Search on -4.8,41.5,9.2,51 from 2012-01-01T00:00:00.000Z to 2012-12-31T23:59:59.999Z
Dataset  Page	searchTime	countTime	totalTime	Nb Results
Syracuse	1	17618	2740	20358	100/922
Syracuse	2	16778	0	16778	100/922
Syracuse	3	16980	0	16980	100/922
Syracuse	4	17043	0	17043	100/922
MongoDBSyracuse	1	21251	9750	31001	100/922
MongoDBSyracuse	2	15383	0	15383	100/922
MongoDBSyracuse	3	15208	0	15208	100/922
MongoDBSyracuse	4	15205	0	15205	100/922