search speed and other suggestions/questions

zeusthedog

hello all,

my first post please be gentle .. I just started playing with itflow ..

a) when i search for an item to add to the invoice .. the search takes a really long time ( i have about 500 items )

b) is there a way we can generate a pdf with logo and attache it to email invoice to customer ?

thanks all .

athornfam2

Seems pretty zippy for me having 74 clients and 180+ assets. What's your resources look like for this installation?

zeusthedog

16gb ryzen 7 1tb nvme

johnny

hey @zeusthedog can you provide an export of your items to the link below.

We'll import and see if we can replicate and then we'll attempt to fix if we spot an issue

https://cloud.itflow.org/s/q7gCLXGNpzgeRmJ

wrongecho

~~Products are pulled using Ajax, it might be worth opening the dev tools > network tab and seeing what's going on with the response.~~ Wrong - they're not.

In reference to the second part of your question, see https://forum.itflow.org/d/1166-send-invoice-pdf-with-email

zeusthedog

done @wrongecho

wrongecho

@zeusthedog

Where is that export from, because it doesn't look like a ITFlow database or GUI export.

zeusthedog

its a csv i imported into another program but when i import into iflow i remove the stuff dont in itflow db columns etc

zeusthedog

uploaded the correctly formatted one ( hope its )

wrongecho

Are you searching for items based on the product name (PRXXXX in your case) ?

zeusthedog

yes

wrongecho

Yeah that worked totally fine for me. Snappy as expected.

I'm assuming you imported them manually into the database table? It would be worth running an OPTIMIZE to ensure indexing is updated.

zeusthedog

yes i did thanks i will do so ..thanks for checking ..cheers