Re: [Pytables-users] performance question ( with source )

[Stefan K. <pon...@ya...>]

Ahh, that's the ticket.  I can get the throughput I need now ( >4000tps
)!!  Another quick questions or so..

1.  If I use a dictionary as a table description ( rather than a
IsDescrition subclass ), how do I tell it what order the columns are? 
Dictionaries are non-ordered?

2.  Is there some type of SQL interface built on top of pyttables?

thanks,
Stefan

--- Francesc Altet <fa...@ca...> wrote:

> A Dilluns 26 Setembre 2005 20:50, Stefan Kuzminski va escriure:
> > Once I calculate an index ( not a specific pytables index, just a
> > vector of row numbers ) that is the new order that the table has to
> be
> > in, I tried to just random access the source table, but that was
> slow..
> >
> > for idx in new_order:
> >    new_table.append( src_table[idx] )
> >
> > I wonder if I should try this approach but in a column oriented
> way?
> > Is there a way to pass to pytables the order that you want the data
> > returned?
> 
> Yes, there is. Try:
> 
>    new_table.append( src_table.readCoordinates(new_order) )
> 
> In the future, one should be able to do:
> 
>    new_table.append( src_table[new_order] )
> 
> as well :-)
> 
> I'm not sure, but you may need to try with 1.2bx accessible in:
> 
> http://www.carabos.com/downloads/pytables/preliminary/
> 
> in order to make readCoordinates to work well (although 1.1.1 should
> work fine, I believe)
> 
> Cheers,
> 
> -- 
> >0,0<   Francesc Altet     http://www.carabos.com/
> V   V   Cárabos Coop. V.   Enjoy Data
>  "-"
> 
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server.
> Download it for free - -and be entered to win a 42" plasma tv or your
> very
> own Sony(tm)PSP.  Click here to play:
> http://sourceforge.net/geronimo.php
> _______________________________________________
> Pytables-users mailing list
> Pyt...@li...
> https://lists.sourceforge.net/lists/listinfo/pytables-users
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com