Re: [sqlite] 2 Questions from a newbie

[.:UgumugU:.]

Hi cstrader,

Just send some table structure and the explain what you are trying todo. 
In my opinion it is not a good way to deal with 2400 tables :)

ugumugu

cstrader yazm?s,:
> I'm just starting with SQLite (from vb.net) and could use some advice.
>
> I have a set of 2400 (could get substantially higher) tables in a single
> database (each table contains daily stock prices for a different stock).
> Each table has 9 columns (all text for now) and some several thousand rows.
> So far so good.
>
> I need to read those tables sequentially and operate on them.  It takes
> about 18 seconds to open each of  the tables in sequence.  (i.e. loop
> through 2400 tables with a select command opening each one)
>
> First question... does that sound about right in terms of speed?  Is there a
> way to store the data that might be faster?  The data are primarily single
> precision -- I'm using text format, but perhaps that's not best?
>
> Second question:
>
> When I open each table I need to add some blank columns to it.  So I include
> some "0 as NewCol" lines to create the new columns with initial 0s.
>
> However, adding 20 new columns in this manner increases the total time for
> the loop from 19 seconds to  49 seconds.  This seems like a long time.  Is
> there a faster way to get these empty columns in?
>
> More questions later I'm sure...
>
> Thanks in advance
>
> cs
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>   

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Crosscompiling Problem

[ugumugu]

Hi,

I followed to below order to crosscompile the source but the end I get 
some undefined reference errors.


Do you have any idea how to solve this problem.

Note: There is no problem when I try to crosscompile ver. 2.8.17. Every 
thing works great.


**
rm tclsqlite.c

PATH=/usr/local/opt/crosstool/arm-linux/gcc-3.3.4-glibc-2.3.2/arm-linux/bin/:$PATH

for i in *.c; do arm-gcc -O -c $i; done

rm shell.o

ar cr libsqlite.a *.o

ranlib libsqlite.a

arm-gcc -o sqlite shell.c libsqlite.a
libsqlite.a(os_unix.o)(.text+0xf6c): In function `sqlite3UnixDlopen':
: undefined reference to `dlopen'
libsqlite.a(os_unix.o)(.text+0xf78): In function `sqlite3UnixDlsym':
: undefined reference to `dlsym'
libsqlite.a(os_unix.o)(.text+0xf84): In function `sqlite3UnixDlclose':
: undefined reference to `dlclose'
collect2: ld returned 1 exit status

**

Thanks and best regards.
F. Ugurtan Erdem


-
To unsubscribe, send email to [EMAIL PROTECTED]
-