Tim or anyone else,

I've used your reverse engineer option to create the Delphi code to create the tables programatically.

If I remember right, I thought you stated that the best/only way in ElevateDB will be to now create / delete tables via SQL only.

Suggestions?

Lance

Lance

Reverse engineer into sql, copy the resulting code into a query component and run it. That's the way I do it now and its easier than Pascal


Roy Lambert

Hi Roy,


> Lance
>
> Reverse engineer into sql, copy the resulting code into a query component
> and run it. That's the way I do it now and its easier than Pascal
>

Yes, but also more more slower in execution.......

Stefano Monterisi

Stefano


Can't say as I'd noticed it being slower. What sort of comparison are we talking about?

Roy Lambert

Thanks Roy...

Will have to change my code to do this, but its not that big a deal...
 I'm just trying to prep myself for a decent transition to ElevateDB.

Lance


Roy Lambert wrote:
> Lance
>
> Reverse engineer into sql, copy the resulting code into a query component and run it. That's the way I do it now and its easier than Pascal
>
>
> Roy Lambert
>
>

Stefano,

<< Yes, but also more more slower in execution....... >>

Not in ElevateDB.  It designed from the ground up to do everything in SQL
and is very quick.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thats great Tim,

I'll start refactoring my code for that, like Roy pointed out.

I had made a mod of your reverse engineer code for additional
flexibility as well as for progress meter.  So I'll have to do that as
well on the SQL side if I have time.

Lance

Tim Young [Elevate Software] wrote:
> Not in ElevateDB.  It designed from the ground up to do everything in SQL
> and is very quick.
>

Hi Roy,
I have notes that creating Tables with SQL is slower (2 or 3 seconds in
tables with a lof of fields) than "traditional" Delphi code.
Sure;
I am waiting for the new faster system in ElevateDb (like Tim said);

Stefano Monterisi

Hi Tim,
I hope that ALL Sql is faster in ElevateDb (but using only the first field
in compound index don't help in this )
I have some complex and scalar queries that require an great SQL engine.
(For one big application I have been forced to use Firebird for obtain a
good performance in execution time (Queries on compound indexes and stored
procedures);

Good Job,

Stefano Monterisi


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> ha scritto nel
messaggio news:AD30E844-A299-4063-A529-850E19A83610@news.elevatesoft.com...
> Stefano,
>
> << Yes, but also more more slower in execution....... >>
>
> Not in ElevateDB.  It designed from the ground up to do everything in SQL
> and is very quick.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Stefano

AFAIK, ElevateDB will have stored procedures but queries and compound
queries is the most improvement I want. I have some large tables (more than
1 million records) and I have to use auxiliar fields simulating compound
indexes, this works but it is not the best way to find records.

I hope Tim put this feature (that lot of users ask for) as soon as possible
because it will put ElevateSoft in a higher level than today.

Regards
Eduardo