Prev: RLGC TRANSMISSION LINE
Next: estimating a system of equations with
From: Joseph Cohen on 2 Jul 2010 10:12
Hello,

I am using the database toolbox to store information to a database, but the speed seems to be rather slow. I am using a JDBC connection (I heard this was faster than ODBC) and I am bypassing the fastinsert function in the way suggested here:

http://www.mathworks.com/support/solutions/en/data/1-21BOPN/index.html?product=DB&solution=1-21BOPN

However, the process is still quite slow and takes a little more than a minute for every mb inserted. The profiler indicates that it is the sending data to the database part of the code that takes up the vast majority of the time.

I'm using a mysql database. And I am storing entries with types: Text, Medium Text, INT, and a VarChar(45). The Medium Text column contains a 500*100 matlab matrix converted to astring and the Text column contains a 1*500 matrix converted to a string.

What should I do?
From: Rune Allnor on 2 Jul 2010 10:45
On 2 Jul, 16:12, "Joseph Cohen" <hypergra...(a)hotmail.com> wrote:
> Hello,
>
> I am using the database toolbox to store information to a database, but the speed seems to be rather slow.
....
> What should I do?

Redesign the database.

Rune
From: Joseph Cohen on 2 Jul 2010 11:55
Rune Allnor <allnor(a)tele.ntnu.no> wrote in message <6781bd54-87fb-4a01-99e5-bb7cfbd18626(a)e35g2000vbl.googlegroups.com>...
> On 2 Jul, 16:12, "Joseph Cohen" <hypergra...(a)hotmail.com> wrote:
> > Hello,
> >
> > I am using the database toolbox to store information to a database, but the speed seems to be rather slow.
> ...
> > What should I do?
>
> Redesign the database.
>
> Rune

How? Whats causing the problem?
From: TideMan on 2 Jul 2010 17:07
On Jul 3, 3:55 am, "Joseph Cohen" <hypergra...(a)hotmail.com> wrote:
> Rune Allnor <all...(a)tele.ntnu.no> wrote in message <6781bd54-87fb-4a01-99e5-bb7cfbd18...(a)e35g2000vbl.googlegroups.com>...
> > On 2 Jul, 16:12, "Joseph Cohen" <hypergra...(a)hotmail.com> wrote:
> > > Hello,
>
> > > I am using the database toolbox to store information to a database, but the speed seems to be rather slow.
> > ...
> > > What should I do?
>
> > Redesign the database.
>
> > Rune
>
> How? Whats causing the problem?

No, Watt's on first.
How's on second.
 | 
Pages: 1
Prev: RLGC TRANSMISSION LINE
Next: estimating a system of equations with