• Registered: 2014-10-04
  • Posts: 154

Topic: Database speed!

Hi,
I've just made a database software using MVDB! Everything works fine unless i reached to 2500 records!
now my DB is so slow ! and I should wait about 10 sec to save every new record!
so how can I solve this problem ?!
Thanks a lot smile

  • Registered: 2014-08-02
  • Posts: 912

Re: Database speed!

Hello sonixax

Not enough informations about your application
.
How many tables have you created ?
How many side tables ?

Do you use pictures in your main table ?
If yes, how are they stored in the table (StoreFile or LinkFile) ?

Also, what is your PC OS ?

Thanks for all your answers, then we shall be able to help you.

JB

  • Registered: 2014-06-25
  • Posts: 863

Re: Database speed!

How do you insert data in you database? Which size is your SQLite.db file?

Which method? Do you use specific scripts? Do you have an antivirus checking on access files?


@Dmitry

There is a very interesting post here, at the end: http://stackoverflow.com/questions/3852 … -very-slow

Is it enabled in MVDB?

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Database speed!

tcoton
It has no relation to this issue.
This is true when importing data.

Dmitry.

5 Reply by sonixax (edited by sonixax 2015-07-07 23:02:42)

  • Registered: 2014-10-04
  • Posts: 154

Re: Database speed!

jean.brezhonek wrote:

Hello sonixax

Not enough informations about your application
.
How many tables have you created ?
How many side tables ?

Do you use pictures in your main table ?
If yes, how are they stored in the table (StoreFile or LinkFile) ?

Also, what is your PC OS ?

Thanks for all your answers, then we shall be able to help you.

JB

Hi,
I have only 2 tables!
And no I do not have any pictures in my tables!
I have 3 PC's , One of them running windows 8.1  anothers running windows 7!
The PC with windows 8 using 2X Xeon E5-2620 with 32GB of ram! another PC's using I7 as CPU with 16GB of ram! (all of them have SSD)
in all of them after about 2500 records inserting is going slow! I don;t know why sad my database file size is only 250KB!!!!

tcoton wrote:

How do you insert data in you database? Which size is your SQLite.db file?

Which method? Do you use specific scripts? Do you have an antivirus checking on access files?


@Dmitry

There is a very interesting post here, at the end: http://stackoverflow.com/questions/3852 … -very-slow

Is it enabled in MVDB?

I do not know! I just using MVDB!
Please check attached file for project files! (There is nothing in Database because All of data's are Private)

Post's attachments

Attachment icon pro.zip 466.03 kb, 455 downloads since 2015-07-08 

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Database speed!

sonixax
You have many scripts for coloring TableGrid and its 2500 records.
Try to disable script for check it.



Also try optimized version
added:

Main.TransGrid.BeginUpdate; 
Main.TransGrid.EndUpdate;

and limited quantity of records for show in TableGrid

     Main.TransGrid.dbLimit := 500;
     Main.KontaktGrid.dbLimit := 500;
Post's attachments

Attachment icon pro_fixed.zip 136.52 kb, 503 downloads since 2015-07-08 

Dmitry.
  • Registered: 2014-10-04
  • Posts: 154

Re: Database speed!

Thanks a lot smile