Recently, I was looking for “best practices” for getting data from MySQL to a numpy array. Thanks to Tim Hochberg on the numpy mailing list, we get the following as the apparently fastest way to bridge the DB-numpy gap:
# CREATE TABLE demo (x REAL, y REAL)
c = conn.cursor()
c.execute('SELECT * FROM demo')
y = numpy.fromiter(c, dtype=[('a',float), ('b', float)])
At least, it was the fastest back in 2006.
Notice: Undefined index: https://www.aidanfindlater.com/atom/1 in system/plugins/coreblocks/coreblocks.plugin.php line 336
[core] line 0: CoreBlocks->action_block_content_meta_links( …1 args… ) system/classes/plugins.php line 80: call_user_func_array( …1 args… ) system/classes/theme.php line 1237: Plugins::act( …1 args… ) [core] line 0: Theme->theme_area( …1 args… ) system/classes/plugins.php line 218: call_user_func_array( …1 args… ) [core] line 0: Plugins::theme( …1 args… ) system/classes/theme.php line 1063: call_user_func_array( …1 args… ) user/themes/habari-mysophobia/footer.php line 3: Theme->__call( …1 args… ) user/themes/habari-mysophobia/footer.php line 3: MysophobiaTheme->area( …1 arg… ) system/classes/rawphpengine.php line 96: include( …1 arg… ) system/classes/theme.php line 534: RawPHPEngine->display( …1 arg… ) user/themes/habari-mysophobia/multiple.php line 50: Theme->display( …1 arg… ) system/classes/rawphpengine.php line 96: include( …1 arg… ) system/classes/theme.php line 534: RawPHPEngine->display( …1 arg… ) system/classes/theme.php line 151: Theme->display( …1 arg… ) system/classes/theme.php line 317: Theme->display_fallback( …1 arg… ) system/classes/theme.php line 418: Theme->act_display( …1 arg… ) system/handlers/userthemehandler.php line 45: Theme->act_display_tag( ) system/classes/controller.php line 186: UserThemeHandler->act( …1 arg… ) system/index.php line 193: Controller::dispatch_request( ) index.php line 21: require( …1 arg… )
Notice: Undefined index: https://www.aidanfindlater.com/atom/comments in system/plugins/coreblocks/coreblocks.plugin.php line 336
[core] line 0: CoreBlocks->action_block_content_meta_links( …1 args… ) system/classes/plugins.php line 80: call_user_func_array( …1 args… ) system/classes/theme.php line 1237: Plugins::act( …1 args… ) [core] line 0: Theme->theme_area( …1 args… ) system/classes/plugins.php line 218: call_user_func_array( …1 args… ) [core] line 0: Plugins::theme( …1 args… ) system/classes/theme.php line 1063: call_user_func_array( …1 args… ) user/themes/habari-mysophobia/footer.php line 3: Theme->__call( …1 args… ) user/themes/habari-mysophobia/footer.php line 3: MysophobiaTheme->area( …1 arg… ) system/classes/rawphpengine.php line 96: include( …1 arg… ) system/classes/theme.php line 534: RawPHPEngine->display( …1 arg… ) user/themes/habari-mysophobia/multiple.php line 50: Theme->display( …1 arg… ) system/classes/rawphpengine.php line 96: include( …1 arg… ) system/classes/theme.php line 534: RawPHPEngine->display( …1 arg… ) system/classes/theme.php line 151: Theme->display( …1 arg… ) system/classes/theme.php line 317: Theme->display_fallback( …1 arg… ) system/classes/theme.php line 418: Theme->act_display( …1 arg… ) system/handlers/userthemehandler.php line 45: Theme->act_display_tag( ) system/classes/controller.php line 186: UserThemeHandler->act( …1 arg… ) system/index.php line 193: Controller::dispatch_request( ) index.php line 21: require( …1 arg… )
Copyright © 1985–2012 af. Powered by Habari and Mysophobia.