Re: [sqlite] SQlite3 Performnace

[Simon Slavin]

On 14 Feb 2014, at 8:54am, techi eth  wrote:

>> What are the changes in performance if I have single SQlite3 Database file
>> (Contain 'N' table) or  'N' Database file each contain single table.

> I have database on single Disk.In that case i see it is better to create
> separate database file.If i am not wrong i will get better edge over
> concurrency in this case ?

If both files are on one disk there is no speed advantage in creating two small 
database files over one big database file.  Your storage device will still only 
do one operation at one time: it will access only one sector of disk or one 
segment of Solid State DRAM.  You will not notice any significant improvement 
in the time taken just by having two files on the same slow device.

> What do you mean by SQlite3 Query with I/O bound ?

The speed of a SQLite operation is usually "bound" to the speed of your 
"Input/Output" device.  Get a faster Input/Output device (i.e. faster storage 
device) and your speed will increase.

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

Re: [sqlite] SQlite3 Performnace

[techi eth]

Thanks.

I have database on single Disk.In that case i see it is better to create
separate database file.If i am not wrong i will get better edge over
concurrency in this case ?

What do you mean by SQlite3 Query with I/O bound ?



On Thu, Feb 13, 2014 at 9:22 AM, Hick Gunter <h...@scigames.at> wrote:

> .timer on (in the sqlite shell)
>
> Unless you are storing the databases on different disks AND your SQLite
> queries are IO bound I don't expect any performance gains.
>
> -Ursprüngliche Nachricht-
> Von: techi eth [mailto:techi...@gmail.com]
> Gesendet: Donnerstag, 13. Februar 2014 10:11
> An: General Discussion of SQLite Database
> Betreff: [sqlite] SQlite3 Performnace
>
> Hi,
>
>
>
> Is there any way I can check SQlite3 Database read/write timing for
> performance measurement.
>
>
> What are the changes in performance if I have single SQlite3 Database file
> (Contain 'N' table) or  'N' Database file each contain single table.
>
>
>
> Regards,
>
> Techi
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
> --
>  Gunter Hick
> Software Engineer
> Scientific Games International GmbH
> Klitschgasse 2 - 4, A - 1130 Vienna, Austria
> FN 157284 a, HG Wien
> Tel: +43 1 80100 0
> E-Mail: h...@scigames.at
>
> This e-mail is confidential and may well also be legally privileged. If
> you have received it in error, you are on notice as to its status and
> accordingly please notify us immediately by reply e-mail and then delete
> this message from your system. Please do not copy it or use it for any
> purposes, or disclose its contents to any person as to do so could be a
> breach of confidence. Thank you for your cooperation.
> ___
> 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

Re: [sqlite] SQlite3 Performnace

[Hick Gunter]

.timer on (in the sqlite shell)

Unless you are storing the databases on different disks AND your SQLite queries 
are IO bound I don't expect any performance gains.

-Ursprüngliche Nachricht-
Von: techi eth [mailto:techi...@gmail.com]
Gesendet: Donnerstag, 13. Februar 2014 10:11
An: General Discussion of SQLite Database
Betreff: [sqlite] SQlite3 Performnace

Hi,



Is there any way I can check SQlite3 Database read/write timing for performance 
measurement.


What are the changes in performance if I have single SQlite3 Database file 
(Contain 'N' table) or  'N' Database file each contain single table.



Regards,

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


--
 Gunter Hick
Software Engineer
Scientific Games International GmbH
Klitschgasse 2 – 4, A - 1130 Vienna, Austria
FN 157284 a, HG Wien
Tel: +43 1 80100 0
E-Mail: h...@scigames.at

This e-mail is confidential and may well also be legally privileged. If you 
have received it in error, you are on notice as to its status and accordingly 
please notify us immediately by reply e-mail and then delete this message from 
your system. Please do not copy it or use it for any purposes, or disclose its 
contents to any person as to do so could be a breach of confidence. Thank you 
for your cooperation.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQlite3 Performnace

[techi eth]

Hi,



Is there any way I can check SQlite3 Database read/write timing for
performance measurement.


What are the changes in performance if I have single SQlite3 Database file
(Contain 'N' table) or  'N' Database file each contain single table.



Regards,

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